+ Reply to Thread
Results 1 to 5 of 5

Move Completed Items to a new worksheet.

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Move Completed Items to a new worksheet.

    Hello. I'm new to this forum, but have seen a lot of helpful threads.

    I have a document with several worksheets in it (one being a completed worksheet and the other being months of the year). I am keeping track of tasks and upon completion, the word "Completed" is typed in column 'G'.

    For the life of me, I can not figure out how to make each line item populate from the current worksheet (May 2013, June 2013, etc) into the "completed 2013" worksheet. I want to make the row hidden in it's current worksheet and populated into the "Completed 2013" worhsheet when "Completed" is typed into the 'G' column.

    Any advice is GREATLY appreciated!
    Last edited by Linzela42300; 05-24-2013 at 03:47 PM.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Move Completed Items to a new worksheet.

    You will need to copy this and paste into each monthly sheet code section in the Visual Basic Editor.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-24-2013
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Move Completed Items to a new worksheet.

    Thank you so much. I'm going to try that Tuesday morning when I get into the office. I'll post an update.

  4. #4
    Registered User
    Join Date
    05-24-2013
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Move Completed Items to a new worksheet.

    I've pasted this in each sheet, but for some reason it still won't work. Nothing populates, nor changes anywhere.

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Move Completed Items to a new worksheet.

    Did you enable macros? The security settings may be on which would prevent macros from working.

+ 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