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
|
|||
|
|||
updating seperate spreadsheets with same data
I have seperate spreadsheets, one with monthly numbers and one with yearly
numbers. how would I go about updating a clients info in the monthly spreadsheet and getting it to update in the yearly spreadsheet without having to go in and manually copy/paste? |
#2
|
|||
|
|||
updating seperate spreadsheets with same data
Take a look at using 3d references in the XL help file. Perhaps something
like: =SUM('Jan:May'!A2) -- Best Regards, Luke M "T" wrote in message ... I have seperate spreadsheets, one with monthly numbers and one with yearly numbers. how would I go about updating a clients info in the monthly spreadsheet and getting it to update in the yearly spreadsheet without having to go in and manually copy/paste? |
Thread Tools | |
Display Modes | |
|
|