Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Main worksheet to automatically update figures on other worksheets
I have a main worksheet with 10 columns with $ values. Each of those 10
columns need to have their own individual worksheet. How do I get the individual worksheet columns to automatically update the main worksheet when changes are made? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Main worksheet to automatically update figures on other worksheets
In the Main sheet you would have a formula like:
=Sheet1!A1 to get a value from A1 of sheet1, and you can copy this down (obviously changing the sheet name and cell reference to suit your situation). In adjacent columns you can have similar formulae, but referring to different sheet names. Hope this helps. Pete "Deb A" <Deb wrote in message ... I have a main worksheet with 10 columns with $ values. Each of those 10 columns need to have their own individual worksheet. How do I get the individual worksheet columns to automatically update the main worksheet when changes are made? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfering info from main worksheet to multiple worksheets | Excel Worksheet Functions | |||
Automatically update worksheets | Excel Discussion (Misc queries) | |||
how do i automatically update % figures daily | Excel Discussion (Misc queries) | |||
how do i format from the main worksheet to the other worksheets s. | New Users to Excel | |||
Update data automatically among worksheets | Excel Discussion (Misc queries) |