Extracting Report from Accounting System outputQuestion: Hoping that I can get some thoughts on how best to pull data for a report from raw accounting system's output. The attached workbook has two worksheets.
1. Worksheet named "Data" is the raw output from our accounting system. The format is seems difficult to work with I may be missing an obvious solution. The data shown on the "Data" worksheet is abbrieviated in reality there would be thousands of rows of "Cost Elements" and years of data ( I only include a couple months as an example)
2. Worksheet named "Report" is the format of the report I'm trying to give our users.
The report needs to total the dollars and hours for each cost element for the periods (months) specified by the user (using drop-down menus).
I'm sort of stuck on how to approach this. Can I work with the accounting data as is or do I need to reformat the data before I can work with it????
Any suggestions would be much appreciated.
Thank you in advance!