T
thayes
I have been racking my head around this and several suggestions were very
close, but I could not get them to work...
I have a user interactive excel session and want to dynamicly collect parts
list, create an order sheet and invoice.
I have a parts list?
Col_A Col_B
widgit A Y
widgit B
widgit C Y
widgit D
I know I need to build an array and index thru and remove the blanks and
nulls...
Desire result, somewhere on the same worksheet:
Order
widget A
widget D
That is it, pretty simple, but I have yet to figur this out.
close, but I could not get them to work...
I have a user interactive excel session and want to dynamicly collect parts
list, create an order sheet and invoice.
I have a parts list?
Col_A Col_B
widgit A Y
widgit B
widgit C Y
widgit D
I know I need to build an array and index thru and remove the blanks and
nulls...
Desire result, somewhere on the same worksheet:
Order
widget A
widget D
That is it, pretty simple, but I have yet to figur this out.