Create an order form from worksheet

jonco · Apr 26th, 2002, 04:49 PM

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?

James · Apr 26th, 2002, 05:17 PM

I can sen you an example if you would like me
to.

James

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 04:49 PM	#1
jonco New Member Join Date: Apr 2002 Location: St. Louis Posts: 1	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?

Apr 26th, 2002, 05:17 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	I can sen you an example if you would like me to. James