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 is 'pulled' from an excel client
inventory. An item 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.e. 4 component parts = 4 lines, 9 component parts = 9 lines

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