+ Reply to Thread
Results 1 to 5 of 5

Identify and Paste New Rows in Old Sheet

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Kansas City, MO
    MS-Off Ver
    Excel 2010
    Posts
    3

    Identify and Paste New Rows in Old Sheet

    Hi,

    I have two sheets in a workbook with identical columns. The combination of Column A and Column E is a unique identifier for each row. When a new row is added to Sheet 2, I need to automatically add the new unique identifier and all other information in the row to the bottom of Sheet 1 and it is very important that the rows do not change in Sheet 1.

    I know this can be done using a button or a Change Event, but I don't know the logic behind either.

    I have attached a spreadsheet similar to the one I am using.

    Please help!

    Thanks,

    AnnaMc
    Attached Files Attached Files
    Last edited by AnnaMc; 09-14-2011 at 01:52 PM. Reason: attachment

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Identify and Paste New Rows in Old Sheet

    When would you want the copy to be made? Is it when both columns A and E have values or is it when other cells in the row are filled as well? There is a danger of triggering a copy too early if data is being entered cell by cell.
    Martin

  3. #3
    Registered User
    Join Date
    09-14-2011
    Location
    Kansas City, MO
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Identify and Paste New Rows in Old Sheet

    MRice,

    Thanks for responding. That is a very good point. My end goal is for the copy to occur when columns A,B,E have been filled in and then the sumproduct formula in column F of Sheet 1 would fill in on the new row.

    I have no idea if this is possible?

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Identify and Paste New Rows in Old Sheet

    Try pasting the following into the Sheet2 tab in the VBA editor (Alt F11)

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-14-2011
    Location
    Kansas City, MO
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Identify and Paste New Rows in Old Sheet

    mrice,

    Thank you so much for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1