|
| 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
May 28th, 2010, 07:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 28th, 2010, 08:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
