Hi All,
I have created a considerably large sized workbook which processes large amounts of data, as a consequence is slow to run and bulky to save multiple copies.
There are currently 40 sheets to the page which are a breakdown of inputs and output pages as well as calculation sheets.
We plan to use this calculator for as many clients as possible, could be in the thousands.
I don't want to save a copy of the workbook for each client rather would prefer to separate the workbook into 2 parts being;
(1) Customer inputs and Outputs
(2) Calculations
And just save part (1) for each customer and there be one version of a master brain sheet (2) that it can reference. This will cut down on the storage as well as processing time. It would be great if I could record a macros to click a button at the end of inputting all the data into (1) which then runs the data through the separate calculation page (2).
Has anyone done a similar task before and has some advice? or is there some literature or weblinks that helped?
Cheers
I have created a considerably large sized workbook which processes large amounts of data, as a consequence is slow to run and bulky to save multiple copies.
There are currently 40 sheets to the page which are a breakdown of inputs and output pages as well as calculation sheets.
We plan to use this calculator for as many clients as possible, could be in the thousands.
I don't want to save a copy of the workbook for each client rather would prefer to separate the workbook into 2 parts being;
(1) Customer inputs and Outputs
(2) Calculations
And just save part (1) for each customer and there be one version of a master brain sheet (2) that it can reference. This will cut down on the storage as well as processing time. It would be great if I could record a macros to click a button at the end of inputting all the data into (1) which then runs the data through the separate calculation page (2).
Has anyone done a similar task before and has some advice? or is there some literature or weblinks that helped?
Cheers
