Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Formula
I have a workbook with multiple data sheets. Each data sheet has a sum total
in cell B4. I created a summary sheet to pull all the totals into it. I entered the following linking formula: ='(1)'!$B$4, now I want to drag this formula down and have it automatically change to the next sheet. For example ='(2)'!$B$4, ='(3)'!$B$4, ='(4)'!$B$4 and so on€¦ Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to too many pages in a formula, how do I get around this? | Excel Worksheet Functions | |||
Linking /Formula Question | Excel Discussion (Misc queries) | |||
Linking formula | Excel Discussion (Misc queries) | |||
Formula linking........Help!!!!!!!!!!!!!!! | Excel Discussion (Misc queries) | |||
Linking formula | Excel Discussion (Misc queries) |