I'm trying to re-organize my inventory report spreadsheet.
It has two issues.
1. The Inventory is listed one style per row, and each column represents a size, and the Quanity on hand of that size for that Item.
I would like it to instead have a new row for each size clearly stating the size next to it, so there is not need to look up and trace down to find the size you're looking at.
2. The columns share a location in the report, but they mean different sizes depending on Gender. All Female sizes are one up from Men's So A Mans item in the first row is an X-Small, but if it's a Womans item in the first row, it's a Small.
This leads to lots of confusion, particularly on large lists where the items are towards the middle of the page.
I'm hoping someone could give me a recommendation on the best strategy to take for this? I'm new to VB, i'm doing this for another department to help them do their job, so I don't have a budget or I would just hire someone so I'm trying to make this happen for them? I appreciate any help I can get.
So, I've got this:
ORD__Item______XSM(smf)_SMM(mdf)_MDM(lgf)____LGM(xlf)____XLM(2xlf)__GEN <--- this column is the indicator what each columns size is MALE(female)
and I'm trying to get this