+ Reply to Thread
Results 1 to 4 of 4

Move Row to new sheet without overwriting

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Move Row to new sheet without overwriting

    Hi all,

    I found examples that get close to what I need, but can't quite adjust the code to finish it off (due to my lack of VBA knowledge). High level, what I'm trying to do is create a macro (button) that when clicked moves all rows that have "Complete" in column "E" to different worksheet named "Archive". The major hurdle i kept running into was if I ran the macro again, it would overwrite the existing data on the "Archive" worksheet. I want it to be, well, an archive and retain existing data, so it should paste in the first empty row. Also had issues with attempting to maintain two rows of headers/titles.

    Attached is a sample workbook.

    Let me know if additional info is needed and thanks for any help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Move Row to new sheet without overwriting

    Sample (4).xlsm

    How's that ?
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Move Row to new sheet without overwriting

    After adjusting some things I think this will work. Thank you!

    My only issue is trying to figure the best way to calculate LastRow in your code. From what I can tell it currently counts the rows with content in Column A, so if I have nothing in column A for a particular row, it throws off the count.

    Thanks Again!

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Move Row to new sheet without overwriting

    Yes , you're dead right...You have to use a column that will contain all records where possible.

+ 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