View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike O.[_2_] Mike O.[_2_] is offline
external usenet poster
 
Posts: 5
Default Copy formulas from non-adjacent cells

Hi,

I'm trying to copy and paste formulas from non-adjacent cells. is this
possible?

For example:

In column A there are SUM formulas in cells A5, A12, A25, etc. I'd like to
copy all of these formulas (but not the cells above and below) and paste them
in column D so that I have the SUM formulas looking at the same cells but in
D (IE: D5, D12, D25, etc.).

Any help is very much appreciated!

Thanks,
Mike