Quotes

**skinner1** · 02-09-2007, 12:43 AM

I have a spread sheet setup Costing/Stocklist. What i would like to do is be able to create a picking list off this sheet on another sheet.
Here is an example:
---------------Costing Sheet---------------------
Item------------Price--------Quantity---------Total
Toothbrush -----$1-------------10--------------$10
Soap------------$3-------------5---------------$15
Chair------------$20----------------------------$0
Table-----------$40-----------------------------$0
Socks-----------$2-------------2----------------$4
Its actually a costing sheet for our quotes, we list all our stock and and equipment under the items column and their price in another. Quantity varies from job to job as does the items we require. I was wondering if there was a way to make a picking list on a new sheet that would automatically place the items on it as needed plus the amount required once a value had been placed in the quantity column on the first sheet.

------Picking List
Item---------------Quantity
Toothbrush------------10
Soap-------------------5
Socks------------------2

It may be simple or impossible, i really dont know. Any help would be greatly appreciated.

**Trebor76** · 02-09-2007, 01:30 AM

Hi,

Enter your stock details into the 'Costings' tab on the attached and make the selections from the 'Selection' tab ((I've shaded the data input cells light green on these tabs).

Then simply copy the range A2:D2 on the 'Selection' down for each new order.

Let me know how it goes.

Kind regards,

Robert

**Trebor76** · 02-09-2007, 01:31 AM

Sorry, it's attached now!

**skinner1** · 02-09-2007, 01:48 AM

This is a copy of the actual work book. I have placed some comments in there to maybe better describe what i am after.

**Trebor76** · 02-09-2007, 01:59 AM

Doesn't my workbook do the same - simply select the relevant stock item from the drop-down list (cell A2 of the 'Selection' tab) and enter the quantity?