I am trying to create a worksheet that will be a 'loading sheet' for my
warehouse operations. I need some help if possible.
What I have is an item number eg, #1, which may have 3 components which all
have to be loaded to ensure it's complete, item #2, may have 4 pieces etc.
What I would like would be for an excel sheet to generate a line for each
component part, in the case of #1, 3 lines all stating #1, 4 lines stating
#2 etc.
I need a cell next to each component to manually write what package # the
warehouse have labelled the piece when loading onto the truck.
If anyone could help, I'd be really grateful.
Thanks in advance.
Jamie