ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying Formulas (https://www.excelbanter.com/excel-worksheet-functions/91868-copying-formulas.html)

Craig

Copying Formulas
 
Not usre this is possible but here goes:

IN Sheet 1 I have $$$ values in columns b d f h i ....and so on. This is
detail caaluclation that go out to column AB. I have a summary page on
sheet two and would like to link to the total cloumns in the above mentioned
column...but the summary page I want the Totals to be in adjacent columns so
I would be using columns a b c d e f .....

I have tried to link the first two cells and then copy the formula accross,
but it does not synchronize with the data in sheet one.

IS there a way to copy formulas in adjacent columns that reference every
other column in another sheet without having to link each individual cell

Thanks for any help!




All times are GMT +1. The time now is 09:50 AM.

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