Prasad_Joshi
12-16-2006, 03:02 AM
Dear All,
I have a worksheet which will have 30-35 sheets. Each having formula for Opening, Closing balance, Cummulative for each day as per attached sheet. I want to keep the data of about 2-3 years in a single workbook. But as each sheet containing many formulae, the size of workbook reaches upto 4-5 MB. It's too big. I dont' want to use the formula. Whenever the data will be added in each sheet, I want to calculate each sheet by VBA & it's report should be generated in Report sheet as per the date selected by dropdown. Please help me.
Sample sheet is attached.
Or can the data will be kept in Access table ?
Thanks in advance.
Prasad
I have a worksheet which will have 30-35 sheets. Each having formula for Opening, Closing balance, Cummulative for each day as per attached sheet. I want to keep the data of about 2-3 years in a single workbook. But as each sheet containing many formulae, the size of workbook reaches upto 4-5 MB. It's too big. I dont' want to use the formula. Whenever the data will be added in each sheet, I want to calculate each sheet by VBA & it's report should be generated in Report sheet as per the date selected by dropdown. Please help me.
Sample sheet is attached.
Or can the data will be kept in Access table ?
Thanks in advance.
Prasad