ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inheriting spreadsheet from another user for budget analysis (https://www.excelbanter.com/excel-discussion-misc-queries/26582-inheriting-spreadsheet-another-user-budget-analysis.html)

trace

Inheriting spreadsheet from another user for budget analysis
 
I have inherited a huge headache of a spreadsheet that I have no idea how to
simplify. I was wondering if anyone knew of a way to make it simpler to
deliver pie graphs, income by sectors etc: It is for a financial analysis of
a companies performance.
HELP!

Michael_Corral

In my experience, people seem to like to keep all data all one sheet. This
may have worked in the beginning, but as you can see, the business grew or
more data was created. I would start breaking them down into more sheets and
workbooks, then start making total sheets and also have graphs in other
sheets that pull data from the new sheets that you have created.
--
Top Notch Admin


"trace" wrote:

I have inherited a huge headache of a spreadsheet that I have no idea how to
simplify. I was wondering if anyone knew of a way to make it simpler to
deliver pie graphs, income by sectors etc: It is for a financial analysis of
a companies performance.
HELP!



All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com