ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy formulas from non-adjacent cells (https://www.excelbanter.com/excel-discussion-misc-queries/246263-copy-formulas-non-adjacent-cells.html)

Mike O.[_2_]

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


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com