Originally Posted by 30bmg

Hello everyone,
trying hard to figure something out, and im at my wits end on how to do it.
I bought a fancy inventory control software package that was very expensive, but its label feature stinks, and im hoping to do it better and easier in Excel.
i would like to build sheet one to include 4 fields
a - item description
b - barcode with the free 3 or 9 barcode i downloaded
c - price that the item sells at
d - amount of item i am ordering from the distributor
i maintain an inventory of items i regularly stock in my store and when i place an order for a bunch of items i would like to place the quantity of the item im ordering in row D and then have the information from A,B, and C autopopulate into sheet 2 muliplied by the quanity in D from sheet 1 so i can easily mail merge multiple labels of items into word for label printing.
If i type 1 into D2 then i would like sheet 2 to autopopulate with A2, B2, and C2 1 time.
If i type 2 into D3 then i would like sheet 2 to autopopulate with A3, B3, and C3 2 different times.
If i type 7 into D4 then i would like sheet 2 to autopopulate with A4, B4, and C4 7 different times.
can anyone please help? I sure would appreciate it!!Mike