Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy user Entry to history (excel 2000)

    I need a macro that can select certain cells on a worksheet. Copy them, and then paste them into a row on a second worksheet (as values). I need the macro to paste to the next row, each time the macro runs, so that a history is kept.

    Can help with the macro coding?

    Many thanks

    Robert

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy user Entry to history (excel 2000)

    What do you mean by "a macro that can select certain cells on a worksheet"? Can you be more specific? Which cells should be selected, what are the selection criteria, are the cells to be selected all in one row, ...?
    Once that is clear, the rest should be straightforward, there are several examples of such macros in the Excel and VB/VBA forum.

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy user Entry to history (excel 2000)

    I have now put the info on 1 row to make the coding easier. So, I'm now looking to copy the cells E60:R60 from worksheet "customer quote" (cells are formula) and paste to another worksheet "quote history", as values. The problem is how to make the macro select the next available row ( in quote history ) each time it runs, so that it maintains a historical list of all quote details.

    many thanks.

    Robert

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy user Entry to history (excel 2000)

    Assuming that you want to paste starting in column A, and that E60 will always be non-blank:

    Sub CopyHistory()
    Worksheets("customer quote").Range("E60:R60").Copy
    Worksheets("quote history").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
    Application.CutCopyMode = False
    End Sub

  5. #5
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy user Entry to history (excel 2000)

    Many thanks Hans
    That code works perfectly.

    Kind Regards

    Robert

Posting Permissions

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