Are the header in D:BK going to already exist?
I'll assume the D:BK headers refer to the WASP Inventory Report? Yes those are the headers and WASP does not provide for filtering what categories are reported.
Do those ever change?
NO, unless WASP reprograms the report functions.
Is that the whole list so if it needs to be added by macro we can simply replicate those headers as shown?
Yes
That's all the "sizes" ever needed?
Yes, unless he manufacturers add new sizes, for now the "Master Inventory" list all the sizes we carry.
In the CSV "item description" column, the sizes are always the last single word?
Yes.
The Master has hidden columns all through it, necessary?
Not absolutely necessary although it does make this report useful for other reports.
Thank you for your help, eventually I hope to convince WASP to expand the functionality of their reports, for now I need to figure out best way to reformat their reports.
Bookmarks