+ Reply to Thread
Results 1 to 3 of 3

Transfer completed task to another sheet

  1. #1
    Registered User
    Join Date
    11-12-2017
    Location
    Cebu, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Transfer completed task to another sheet

    Hi guys,

    I am currently making a tracker so that I can track my tasks each day. Is it possible to transfer the completed tasks to another sheet?
    I have a simple sheet from A to K with K as the column where I put the drop down if its completed or not. It works if I use a drop down but I want it to be automatic. like if A to J has value then it will automatically transfer the row to another sheet. Here is a code I found online but I am getting error when I want it to be automatically transfer A to J granting that they will have values.

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 11-21-2017 at 08:28 PM. Reason: Please use code tags!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Transfer completed task to another sheet

    Something has to trigger the code. What do you want that to be? Most people use it the way you say it works, that is, column K has a drop down to mark to complete and it transfers.

    If you have A - J filled out, something has to trigger the action. Again, what should it be?
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    11-12-2017
    Location
    Cebu, Philippines
    MS-Off Ver
    2010
    Posts
    4

    Re: Transfer completed task to another sheet

    Hi Jeff,

    Thanks for taking the time to reply. I actually have a drop down for column J with a choice of YES or NOT Required. It doesn't matter what is chosen on it but as long as there is a drop down chosen there then i would actually want it that the transfer takes effect immediately.. granting that A to I would have value and no empty cells.

    Thank you so much!

+ 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. transfer completed task to a different worksheet
    By drnote5238 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2017, 06:31 AM
  2. Text automatically entered to see if task was completed in time
    By alonsogar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2016, 07:38 AM
  3. [SOLVED] Formula to add date when task is completed
    By rizmomin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2015, 02:17 PM
  4. Calculating TAT Received and Completed task
    By hecgroups in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2015, 01:06 PM
  5. Replies: 1
    Last Post: 01-06-2015, 04:16 AM
  6. Replies: 3
    Last Post: 11-11-2011, 08:14 PM
  7. Completed task indicator in Gantt
    By excelhelp18 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2009, 06:52 AM

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