#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig
 
Posts: n/a
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formulas to other cells. Keeping references w/o $ sign. GregP1962 Excel Discussion (Misc queries) 10 April 22nd 06 03:11 AM
Copying formulas to other cells. Keeping references w/o $ sign. GregP1962 Excel Discussion (Misc queries) 3 April 21st 06 07:24 PM
excel 2002 - copying formulas to another worksheet Greg Excel Discussion (Misc queries) 2 January 28th 05 10:23 PM
Excel & Copying Formulas JComer Excel Worksheet Functions 1 October 28th 04 07:17 PM
Copying formulas MsAmethyst Excel Worksheet Functions 1 October 28th 04 05:55 PM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"