If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Worksheet updates
Is it possible to have one worksheet automatically update
a master worksheet?? I have 8 worksheets, and I have one master worksheet. When I make changes to one of the 8 worksheets, I want to know if I can set it up to automatically update the master worksheet. |
#2
|
|||
|
|||
Worksheet updates
-----Original Message----- Is it possible to have one worksheet automatically update a master worksheet?? I have 8 worksheets, and I have one master worksheet. When I make changes to one of the 8 worksheets, I want to know if I can set it up to automatically update the master worksheet. . on your masterworksheet, begin the formula by pressing the equals sign, then go to the worksheet and click on the cell that you want the masterworksheet linked to. Then press tab and it will take you back to the worksheet. This connects the two worksheets and the master will automatically update each time that you enter information on the individual worksheets. |
Thread Tools | |
Display Modes | |
|
|