+ Reply to Thread
Results 1 to 10 of 10

Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    Mill Creek, WA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    Workbook with sheets Assigned and Completed. I want to be able to select a row from sheet Assigned (not always the first row) and move the data to sheet Completed in the next available row (archiving completed work). I want the selected row to then be deleted after it has been moved and any rows that were under it to move up so there are no empty rows. I've found many different variations but have not found one that does all of what I want. My sheet has 26 columns that need to be copied/moved.

    I have a procedure to send an email to my group that has the Assigned information (different people have different pieces of the assignment) in a workbook that I am trying to clean up. I won't know if it works until I get the sheets thing figured out.

    Thanks in advance for your help.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    Hi papabob1954,

    Welcome to the forum!!

    What's the flag to determine whether a row is moved from the Assigned tab to the Completed tab?

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    12-14-2012
    Location
    Mill Creek, WA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    I was thinking an x in an empty cell in front of the data

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    No, I mean how do you know to move a row from the Assigned tab to the Completed - what's the indicator (flag) that tells you that the work is now completed?

  5. #5
    Registered User
    Join Date
    12-14-2012
    Location
    Mill Creek, WA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    After I enter the data in all the columns, then send the email to the group with that data, it is completed. I have assigned the work to the people in my group.

  6. #6
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    So after the email is sent all the data in Assigned tab should be moved to the Completed tab leaving no rows in the Assigned tab?

  7. #7
    Registered User
    Join Date
    12-14-2012
    Location
    Mill Creek, WA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    The selected row on the Assigned tab gets moved. There will be data for other assignments that I need to assign on the Assigned tab. So like I am assigning devices to test. each device has multiple pieces to test and so I will enter a name under each piece and then send the assignment email out. I may have 5 or 6 devices at one time to assign and I want to look at the spreadsheet to make sure I haven't over/under assigned a person. If I'm good with that, I'll send the email, one device at a time.

  8. #8
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    OK, let me know how this goes (just initially try it on a copy of your data):

    Please Login or Register  to view this content.
    Regards,

    Robert

  9. #9
    Registered User
    Join Date
    12-14-2012
    Location
    Mill Creek, WA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    Thanks Robert. That worked perfectly. I was able to import my sendemail macro over to my new spreadsheet.

  10. #10
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up

    You're welcome - I'm glad we were able to get it sorted for you.

    If you could mark the thread as solved when you get a moment, it would be appreciated.

    Regards,

    Robert

+ 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