Copying formulas with ranges
Thanks. Worked perfectly once I adjusted the appropriate column references to be relative instead of absolute.
Carla
----- drabbacs wrote: -----
This trick should work.
Since you want your formulas to work on ranges A-E, G-H, M-
Q, etc What you do is write your formula(s) in column A
and then copy/paste into columns G, M, S etc. In other
words, paste in every 6th column (or whatever spacing).
Then select the blank columns between and delete. Voila.
Good Luck
|