How do you copy and paste something automatically?

Sami

Board Regular
Joined
Mar 4, 2002
Messages
122
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!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Could you give use some more information on the lay out of the sheet, which columns have what in them
 
Upvote 0
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!!!!
 
Upvote 0
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,
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
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,
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top