• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

TO DO LIST

S

Shabbo

Member
Dear Sir,


I have to do list which will help me to manage my office work, and I wanted to make the way like


1) I have date 2) Task name 3) Status


Next sheet will be the next working day will show current dated task added plus carry forward the “pending” task form my previous day.


Eg : 2nd December 2016 my bank recon is pending so I have carry forwarded the same to 3rd December 2016 the same task I wanted to create automatically.
 

Attachments

  • TO DO LIST.xlsx
    10.2 KB · Views: 7
Hello Shaboo.

I thinks this works better with Excel vba Coding... Rather then Excel.
 
Hello Shaboo.

May be this way!!!!!!!!

Excel attached..Click on the Button "Run" before that understand how macro works.

When you open this on file on the day Example Today Date is : 03 12 2016.

Then macro will search for yesterday date that is : 02 12 2016 and check for Peding items and move those to current date by adding new sheet with current date : 03 12 2016.

Hope this help...Please let me know.

Below code for your quick reference!!!!!!

Sub TodoList()
Dim TodayDt As String
Dim YesterDt As String

TodayDt = Format(Now, "DD MM YYYY")
YesterDt = Format(Now - 1, "DD MM YYYY")

For Each tbname In ActiveWorkbook.Sheets
If tbname.Name = YesterDt Then
tbname.Activate
tbname.Rows("3:3").Select: Selection.AutoFilter
tbname.Range("$A$3:$C$100").AutoFilter Field:=3, Criteria1:="Pending"
tbname.AutoFilter.Range.Copy
Sheets.Add After:=ActiveSheet
ActiveSheet.Name = TodayDt
Range("A3").PasteSpecial
ActiveSheet.Columns("A:C").AutoFit
End If
Next tbname
End Sub


Please be advised that this code can also be used in Workbook open event...So that on your beginning of your day when you open this will automatically move pending to current date..

Thanks!!!!!!
 

Attachments

  • TO DO LIST.xlsb
    17.7 KB · Views: 15
Monty said:
Hello Shaboo.

May be this way!!!!!!!!

Excel attached..Click on the Button "Run" before that understand how macro works.

When you open this on file on the day Example Today Date is : 03 12 2016.

Then macro will search for yesterday date that is : 02 12 2016 and check for Peding items and move those to current date by adding new sheet with current date : 03 12 2016.

Hope this help...Please let me know.

Below code for your quick reference!!!!!!

Sub TodoList()
Dim TodayDt As String
Dim YesterDt As String

TodayDt = Format(Now, "DD MM YYYY")
YesterDt = Format(Now - 1, "DD MM YYYY")

For Each tbname In ActiveWorkbook.Sheets
If tbname.Name = YesterDt Then
tbname.Activate
tbname.Rows("3:3").Select: Selection.AutoFilter
tbname.Range("$A$3:$C$100").AutoFilter Field:=3, Criteria1:="Pending"
tbname.AutoFilter.Range.Copy
Sheets.Add After:=ActiveSheet
ActiveSheet.Name = TodayDt
Range("A3").PasteSpecial
ActiveSheet.Columns("A:C").AutoFit
End If
Next tbname
End Sub


Please be advised that this code can also be used in Workbook open event...So that on your beginning of your day when you open this will automatically move pending to current date..

Thanks!!!!!!
Click to expand...
Macro is not working
 
Hello Shabbo...

Thanks for highlighting...
Can you please let me know the error may be a screen shot..to help you.
 
You must log in or register to reply here.
Back
Top