I have a worksheet (called Inventory)that has about 1500 rows containing data about products (i.e. Code#, name, selling price, case cost, each cost, %MU, SSP, etc).
Weekly I have to create and print an order of say 70-80 of those items from that list.
On a different sheet (OrderSheet) in the same workbook, I want to be able to enter a code number and quantity of items and have it pull the items and their relative data from the Inventory sheet and add that info to the OrderSheet. I can then print out the OrderSheet when done. (The Inventory sheet is not arranged numerically by code numbers, but by product type.)
What would be the best way to approach this?
Weekly I have to create and print an order of say 70-80 of those items from that list.
On a different sheet (OrderSheet) in the same workbook, I want to be able to enter a code number and quantity of items and have it pull the items and their relative data from the Inventory sheet and add that info to the OrderSheet. I can then print out the OrderSheet when done. (The Inventory sheet is not arranged numerically by code numbers, but by product type.)
What would be the best way to approach this?