To Do list help - to add two more columns to the current code

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Parita Pandya
    New Member
    • Sep 2013
    • 3

    #1

    To Do list help - to add two more columns to the current code

    I am preparing a to do list in which there is Status (completed / not yet) and Task name in sheet 1. In sheet 2 (completed) the task which is marked completed is moved with the current time.
    Now I need to work out on adding two more columns D (person) and E (estimated completion date) in Sheet 1. So, When I mark the task as Completed & click on button, all 3 details i.e. Task name, Person and Estimated completion date should move to Sheet 2.

    For the reference, I have added the file here. Macro codes are defined.

    I am unable to edit the code as per above requirement.
    Any help would be greatly appreciated.
    Attached Files
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    Here you are copying the data from column B:
    Code:
            ElseIf moveThis Then
                Range("removedTodos").Offset(tmpCount + 1).Value = cell.Value
                Range("removedTimes").Offset(tmpCount + 1).Value = removalTime
                moveThis = False
                tmpCount = tmpCount + 1
            End If
    You managed to write the code for this, so how difficult would it be to add two more lines which also copy the values of columns D and E ??

    Comment

    Working...