+ Reply to Thread
Results 1 to 1 of 1

Move rows to another sheet based on column input

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2003
    Posts
    1

    Move rows to another sheet based on column input

    Greetings all!

    I'm sure what I'm about to post has been covered somewhere, but my searches have come up blank and I can't seem to modify the solutions to similar inquiries to meet my needs. I am using Excel 2003.

    I am using the attached workbook to track my work progress on various projects. There are four sheets in the workbok, "Tasks", "Reports", "Completed Tasks", and "Settings".

    I want the ability to move rows from the "Tasks" sheet to the "Completed Tasks" sheet by clicking the "Move Completed Tasks" button. I am interested in moving columns B-K for all rows that are marked as "Completed" in column G to colums B-K in the "Completed Tasks" sheet. At the same time, I want all completed tasks removed from the "Tasks" sheet without messing up the formatting (such as formulas and gridlines). I'm not concerned about the formating on the "Tasks Completed" sheet, so long as the layout is the same as the "Tasks" sheet. Additionally, the "Completed Tasks" sheet needs to add newly completed tasks below the last completed task to make an ever growing list of work completed.

    Any help is greatly appreciated!!!!

    -Jake
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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