View Single Post
  #3  
Old December 18th, 2003, 07:06 PM
Carla S
external usenet poster
 
Posts: n/a
Default 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