Hi all,
I'm trying to make a spreadsheet for my to do list. I'd like a few command buttons to filter this in a number of ways - tasks due today, overdue tasks, tasks due in next week etc, by context (work / personal) etc.
I am no good at coding so have tried to record a number of macros, but the filters don't behave as expected when run as a macro. Currently I have
Can anyone see why this might not be behaving?
Full spreadsheet is here: https://dl.dropbox.com/u/1337635/ToDo.xlsm
Thanks in advance for any help!
Cheers
Jon
I'm trying to make a spreadsheet for my to do list. I'd like a few command buttons to filter this in a number of ways - tasks due today, overdue tasks, tasks due in next week etc, by context (work / personal) etc.
I am no good at coding so have tried to record a number of macros, but the filters don't behave as expected when run as a macro. Currently I have
Code:
Sub FilterTaskByDate_Today()
'
' FilterTaskByDate_Today Macro
'
'
ActiveSheet.Range("$A$3:$G$300").AutoFilter Field:=5, Criteria1:="Today()", _
Operator:=xlAnd
End Sub
Can anyone see why this might not be behaving?
Full spreadsheet is here: https://dl.dropbox.com/u/1337635/ToDo.xlsm
Thanks in advance for any help!
Cheers
Jon