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
|
|||
|
|||
Links between workbooks and keeping file sizes down
Hi! Can anyone help.
At the moment I am working on a Workbook which involves measuring performance within an organisation. There are 7 areas of measurement and 6 Geographical regions to measure these by. The results are to be sent to top management. These people dont need to see all the calculations just the results. Basically i wish to set up a workbook which involves all the raw data for any calculations. I will link these to the "viewers" workbook and, through calculations and macros they will see the results measured. Problem: i have been given the "viewers" workbook and i wish to link it to this rough work workbook. this i want to do without the need for the user to have to see this rough work workbook. (i dont want absolute links to a file but i do want to link in such a way that a change in the rough work book will be shown in the "viewers" workbook The "viewers" workbook will be emailed to all top managers |
#2
|
|||
|
|||
Links between workbooks and keeping file sizes down
Hi Steve,
With the user workbooks, you'd probably do well to have a summary sheet that brings together all of the data to be exported to the management workbook. This makes any kind of inter-workbook linking easier to manage. In the management workbook, you could use formulae in the required cells to pull in data from each of the user workbooks. But, if you really want to keep the size of the management workbook to a minimum, you might get something smaller by using vba to import the data from the user workbooks. The vba approach takes more work and, unless you're importing a lot of well-structured data in blocks, might not save much - you may even end up with a larger management workbook. Cheers "steve" wrote in message ... Hi! Can anyone help. At the moment I am working on a Workbook which involves measuring performance within an organisation. There are 7 areas of measurement and 6 Geographical regions to measure these by. The results are to be sent to top management. These people dont need to see all the calculations just the results. Basically i wish to set up a workbook which involves all the raw data for any calculations. I will link these to the "viewers" workbook and, through calculations and macros they will see the results measured. Problem: i have been given the "viewers" workbook and i wish to link it to this rough work workbook. this i want to do without the need for the user to have to see this rough work workbook. (i dont want absolute links to a file but i do want to link in such a way that a change in the rough work book will be shown in the "viewers" workbook The "viewers" workbook will be emailed to all top managers |
Thread Tools | |
Display Modes | |
|
|