How do you copy and paste something automatically?

[Sami]

Ive got a stock worksheet and a reorder sheet. Im using conditional formatting so that when any stock goes below 10 quantity then it goes red. But how do i make the products that go red get copied automatically and then pasted into the reorder sheet? lil help plz!

[Paul B]

Could you give use some more information on the lay out of the sheet, which columns have what in them

[Sami]

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!!!!

[Sami]

does any1 no?

[Sami]

any1???! plz!!!

[Barrie Davidson]

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!!!!

Couple of questions:

1. When your quantity gets to 10 (or less), how much do you want to order?

2. How is the value of quantity changed? Is it manual or formula?

3. Is the file layed out with:
• Row 1 a header for product name, ID and price
• Row 2 contains data for Row 1
• Row 3 is blank
• Row 4 a header for quantity, total value, and supplier.
• Row 5 contains data for Row 5.

Regards,

[Sami]

kool: the answers are :

Couple of questions:

1. Im not sure will i be able to program each item seperately?

2.Its by formula when there is a sale (oh yeah i dont no how to do this either lol :S)

3. No both the files are layed out with the headings i gave but there all in coloums i.e : Product Name in column A, Product ID in column B etc. there all in the nxt column respectively.

thanks 4 d help i just hope i can finish this project.

[Barrie Davidson]

On 2002-03-08 12:02, Sami wrote:
kool: the answers are :

Couple of questions:

1. Im not sure will i be able to program each item seperately?

How about using an additional column where you can input the re-order quantity? How many records are in your worksheet?

[Sami]

erm loads probably
what are d formulas or vb codes?

[Barrie Davidson]

On 2002-03-08 12:14, Sami wrote:
erm loads probably
what are d formulas or vb codes?

Sami, I don't understand your response.

My questions were:
1. Can you put the re-order quantity amount in an adjacent column (say column G, based on your data stated earlier)?

2. How many records (rows) do you anticipate having in your spreadsheet?

Regards,