Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidated Sheets
I've consolidated some spreadsheets, but Im trying to get my consolidated
sheet to "read" from my originals? How can I accomplish this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidated Sheets
Hi Dana,
If I have understood your requirements properly, you have data in many sheets and you have consolidated them in a new sheet. By your statement "the consolidated sheet to read from my originals", I understand that it should update the data in the consolidated sheet when ever the data in the sheet undergoes change. If this is right and you have used the Data Consolidate option, tick "Create links to source data". According to "Help", this should ensure automatic updating of data in the consolidated sheet. But I have not found this useful. I had used a pivot table instead more successfully. The pivot table consolidates data and also updates it when ever you press the "Refresh" button (see ! mark) in the pivot table toolbar which automatically appears when ever you create a pivot table. If your updating means insertion of new data say at the end of each worksheet, I suggest that while taking the ranges to be used for the pivot table in each worksheet, include one extra row. While inserting new data use the blank row that too after inserting a new row ( so that one blank row always remains below). The range specified for the pivot table thereby remains dynamic. "Dana" wrote: I've consolidated some spreadsheets, but Im trying to get my consolidated sheet to "read" from my originals? How can I accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Consolidated Spreadsheet... | Excel Discussion (Misc queries) | |||
Consolidated Excel Sheet | Excel Worksheet Functions | |||
Consolidated Pivot Tables | Excel Discussion (Misc queries) | |||
Reports on the plan of consolidated payments in EXCEL | Excel Discussion (Misc queries) | |||
showing the contents of a consolidated cell | Excel Worksheet Functions |