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) 101__redwidget_____0_______1__________0__________0___________0______MA 102__Pinkwidget____0_______0__________2__________0___________0______FE 102__whiteWidget___1_______0__________0__________1___________0______FE 103__redwidget_____0_______1__________1__________0___________0______MA
and I'm trying to get this