ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy formulas to cells absolute rows and variable columns (https://www.excelbanter.com/excel-discussion-misc-queries/68323-copy-formulas-cells-absolute-rows-variable-columns.html)

Mark

copy formulas to cells absolute rows and variable columns
 
I am trying keep my row set and have the columns vary when copying cells.

I know that $D33 makes the row change but how do I invert the copy feature?

Pete

copy formulas to cells absolute rows and variable columns
 
Try:

D$33

Pete



All times are GMT +1. The time now is 11:36 AM.

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