I have the following production table (see image) and would really appreciate any help to you could provide to help me come up with an excel macro that could create a more condensed production output table (see image) that would be useful for inventory reports.
table.JPG
Certain items produced aren't useful to us, so we don't track them with an item code. So a "0" for item code would be fine in the output if that helps.
Is the output easily possible?
Bookmarks