+ Reply to Thread
Results 1 to 2 of 2

Copy rows from one worksheet to another, if certain conditions me

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    68

    Copy rows from one worksheet to another, if certain conditions me

    Dilemma is as follows;

    Sheet 1 Table 1:

    I need to past Column A, B, C, and D into the 1st blank row in Sheet 2 IF a date is entered in column D.

    If a date is then later entered into Column E, I need to again paste Column A, B, C, and E (the E date would then gow into Row D on Sheet 2).

    Sample spreadsheet attached.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-15-2012
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Copy rows from one worksheet to another, if certain conditions me

    After piecing together related code I've found in searches, I'm almost there but the copy portion of it doesn't act quite right. It doesn't copy to the last empty row in "table2". It copies to the 1st empty row after table 2. This is what i'm working with:

    So question now is, how do I revise code so that this portion:
    Please Login or Register  to view this content.
    Deosnt select the first empty row after table 2, but the 1st empty row within table 2.

    Please Login or Register  to view this content.
    ON sheet 1 I put the following code:

    Please Login or Register  to view this content.

+ 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