Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
consolidation link template?
Hi,
Presently, I consolidate data from 60 different files, each consisting of about 9 sheets. Right now, we have to wait until all data is completed before we consolidate. I was attempting to set it up by creating links to source data so as data is entered, it automatically adds up. This process has to be repeated every year, and it is tedious. The question is, how can I consolidate data from a consolidate template where data changes from year to year, so I don't have to go through this process every year? Please help me out. I'm deperate. I DO NOT want to do this every year. Also, the create links also gave me some problems. Many thanks for any assistance. Nanika V. Brathwaite Ministry of Health Bahamas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link one sheet of data to a template? | Excel Discussion (Misc queries) | |||
Can you link many workbooks to one template? And Update? | Excel Discussion (Misc queries) | |||
Template design and consolidation | Excel Discussion (Misc queries) | |||
How do I link a template to a chart? | Excel Discussion (Misc queries) | |||
I can I select cells in a template and link it to a database? | Excel Discussion (Misc queries) |