| Home |
| Search |
| Today's Posts |
|
#1
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening two seperate Excel spreadsheets | Excel Discussion (Misc queries) | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Comparing data and updating spreadsheets | Excel Discussion (Misc queries) | |||
| How to link cells in seperate spreadsheets without the $ | Excel Worksheet Functions | |||
| need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
Linear Mode
