Hello,
First of all, thanks for helping with this. This is a great forum and resource.
I'm working on a project where I have an "input" sheet and various sheets for clothing inventory/sizes.
The input sheet has description and other misc data and inventory by size. (ie 10 units for size 6, 20 for size 7, so on)
What would like to accomplish is to have a macro that will parse all inventory on the input sheet and copy all the size 6 products to the "6" sheet, and then size '7", "8", so on."
To add more complexity, the input sheet might have sizes that vary between each product. ie shoes, mens will go from 7-12 and women from 5-10.
And lastly, to combine all the different sizes/inventory to 1 sheet, showing the size of the the product on a column.
Please see attached xls
Thanks again!
Bookmarks