Hi,
I have a sticker template made up of 6 stickers that I'd like to copy the part number and its descripton from a second worksheet which includes list of part numbers.
My challange is I want to auto populate sticker content on template with xls functions depending on number entry "for number of pallets" in the stock.
(e.g. first sticker, second, third stickers should only be filled data on line2 automatically, and other in a row) I could not do it wiht vlookup combined with with # of pallets to auto populate stickers automatically.
Any
----A-----------------B--------------------C----------
1--Part Number---- Part Description----Number of pallets
2--100485----------Apples---------------3
3--100577----------Pears----------------2
4--100943----------Oranges-------------1
I have a sticker template made up of 6 stickers that I'd like to copy the part number and its descripton from a second worksheet which includes list of part numbers.
My challange is I want to auto populate sticker content on template with xls functions depending on number entry "for number of pallets" in the stock.
(e.g. first sticker, second, third stickers should only be filled data on line2 automatically, and other in a row) I could not do it wiht vlookup combined with with # of pallets to auto populate stickers automatically.
Any
----A-----------------B--------------------C----------
1--Part Number---- Part Description----Number of pallets
2--100485----------Apples---------------3
3--100577----------Pears----------------2
4--100943----------Oranges-------------1
