I’m attaching a file to show you what I need help with. We have data dumped to a spreadsheet every month or so from a database query. The data lists each dept’s actual budget numbers in one long table. Our director wants the data summarized in separate tables for each department. At first, I thought of subtotals. But she wants the labor numbers first with the type of labor split (regular, Other and OT), then the total labor, then the Direct and Materials line items. I can’t see how to break down subtotals the way she wants it to show.
I thought about trying Vlookup, but either that won’t work, or I’m just not clever enough to figure out how to use it for this example.
How can I get the data to summarize in the required format? I am totally code illiterate. I can copy/paste if someone has the code for this somewhere.
Would you mind, please, looking at the attached file and telling me how to set this up for her – keeping in mind that the data will be updated each month and there may be additional lines added to some of the departments each month.
Thank you for any help you can provide.
