I have just been given the task of doing the revenue reporting for the company. Does anyone know of any sites I can visit to get ideas on how to present the data and store it efficiently in Excel.
The current method uses 10 workbooks with 5 to 40 spreadsheets each. From these 10 workbooks, 10 diffrent sheets are copied to the 1 main report which is sent to Mgmt. There are a lot of links and formulas that slow down my computer. I was thinking of moving the data to Access but, what about the calculations?
Any ideas, suggestions or if you have encountered the same issues, please respond.
Thank you
Parra
The current method uses 10 workbooks with 5 to 40 spreadsheets each. From these 10 workbooks, 10 diffrent sheets are copied to the 1 main report which is sent to Mgmt. There are a lot of links and formulas that slow down my computer. I was thinking of moving the data to Access but, what about the calculations?
Any ideas, suggestions or if you have encountered the same issues, please respond.
Thank you
Parra