Hello All! I was hoping someone might be able to give me a hand.
I am attempting to automate the population of a plant productivity report for my employer. Every Tuesday I receive two tables that I enter manually into multiple spreadsheets in order to derive the report that my bosses are looking for. One of those tables looks like this:
Bored | Bored | 1435.48 | 328.07
Cylinders | Cylinders | 1677.9 | 322.97
EM | EM | 432.52 | 124.38
Exits | Exits | 2096.17 | 755.53
Maintenance | Plating | 338.18 | 87.1
Mortise | Mortise | 1764.85 | 548.08
Plating | Plating | 394.4 | 108.68
Polishing | Plating | 424 | 153.63
Powder Coat | Plating | 120 | 45.5
Receiving | Shipping | 111.07 | 21.77
Shipping | Shipping | 592 | 231.98
Tool & Die | Cylinders | 104 | 25.93
Waste Water | Plating | 40 | 19.5
I am currently taking both tables and loading them into a multi-dimensional dictionary without issue. The problem that I'm running into is that I can't figure out a clean and concise way to get the values out of the dictionaries and into the spreadsheets. In certain cases, such as the table above, I need to sum the value columns (columns 3 & 4) when the profit center group (column 2) is the same, prior to populating the spreadsheet.
Perhaps I'm going about this the completely wrong way? I'm not sure. Hopefully someone has some ideas. I've uploaded a copy of the workbook I have been working on. The tables that I'm using are on Sheet1 and the sheets I'm trying to populate are tabs 2-5. Thanks in advance for any help- it's truly appreciated!
Justin
Bookmarks