On 2002-03-07 10:33, Sami wrote:
Yeah sure. The stock workbooks looks like this:
Product Name Product ID Price
Super Fish Food FF01 £1.99
Quantity Total Value Supplier
10 £19.90 Aquatics Ltd.
So when the quantity goes below 10 or equal 2 10 i need the whole of this row to copy and go into the Re-order sheet which looks like this:
Product Name Price Quantity Required
Kool Kat collars £2.99 10
Cost Supplier
£29.90 Wundpet
This would be a real help!!! The quantity required could all b say 10 and the cost could b a formula. i hope this can b answered.
THANK U!!!!