Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: How do you copy and paste something automatically?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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



  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    does any1 no?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    any1???! plz!!!

  6. #6
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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,

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.




  8. #8
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    erm loads probably
    what are d formulas or vb codes?

  10. #10
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •