+ Reply to Thread
Results 1 to 3 of 3

Making tasks "Completed" and moving them to another sheet

  1. #1
    Registered User
    Join Date
    05-07-2018
    Location
    Oahu, Hawaii
    MS-Off Ver
    2007
    Posts
    2

    Making tasks "Completed" and moving them to another sheet

    I have run into a scenario that may help myself and fellow coworkers. I believe there is a way to do this but I personally don't know how to make it work.

    I have a list of tasks that needs to be complete, and its an ongoing list. I would like to make a column called "completed" and when someone completes the task they write completed in the column and it will take that entire row and move it to another sheet. Making the Sheet 2 completed tasks only, that way the first sheet will be tasks that still need to be completed.

    My original thoughts:
    1. If statement, but thought maybe it would be hard to move the entire row.
    2. Macro, I really haven't worked with macros enough to create something like this.

    Thanks in advance!

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Making tasks "Completed" and moving them to another sheet

    I would just use a filter to exclude the Completed tasks from the view.

    If you need a macro you would be best attaching a sample workbook with a similar layout to what you would be using.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    05-07-2018
    Location
    Oahu, Hawaii
    MS-Off Ver
    2007
    Posts
    2

    Re: Making tasks "Completed" and moving them to another sheet

    You're completely right! I never thought of something so simple, I guess I was thinking to deep into it.

    I still am curious how I would do something similar to what I had in mind. Thanks for helping me with making something so much simpler than I was trying to do!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Update list of tasks in several sheets based on "Master-list" in sheet A
    By Jacob2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2015, 06:22 AM
  2. Managing "delegated tasks" in an Outlook "Send Only" account
    By on_way_to_fame in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-13-2013, 12:21 AM
  3. Auto-move row to another sheet when cell = "Completed"
    By supergirl21 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-21-2013, 02:03 AM
  4. If "Completed" then move entire row to "Completed" worksheet
    By Reed1620 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2013, 01:59 PM
  5. [SOLVED] Macro to Cut "Completed" Rows from Sheet 1 and Paste in Sheet 2
    By pfm721 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 02:33 PM
  6. Moving entire row from the "Schedule" worksheet to "Completed" worksheet
    By Redveck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 02:30 PM
  7. Making the Tools>Options...Calculation "Manua"l Vs "Automatic" a Button.
    By Ecoich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2007, 07:50 PM

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