Excel template: Getting Things Done (vba)
In this blog post I am going to demonstrate a simple workbook where you can create or delete projects and add "next" actions to each project. You can also mark actions completed.
"The Getting Things Done method rests on the idea that a person needs to move tasks out of the mind by recording them externally, so the mind is free from the job of remembering the tasks that need to be completed. One can concentrate on performing the tasks, instead of remembering." Source: Wikipedia
Add a project
Delete a project
Select a project
Add actions to a project
Mark an action completed
Download excel *.xlsm file
Getting-things-done-template-v1.xlsm
Related posts:
Excel vba: Select cell A1 on all sheets before you close a workbook
Recommended categories
The save bottom doesn't work, when click completed and save, cannot pass 1 to completed status.
John,
you are right. I believe it is working now. I have uploaded a new file:
Getting-things-done-template-v1.xlsm
I would love to use an excel template for GTD, which is why i downloaded yours. I don't know how to use all the files found in the zip file though. They open as lines of code on webpages
Do you have just an excel sample worksheet that I can use?
Thanks for any help,
Zelda
Zelda,
The attached file is a excel *.xlsm file. I am not sure why it is opened as lines of code on webpages. It works here.
Thanks.
When I save the file to to my computer, it saves & therefore opens as a winzip file, with many files within. Should I pick one of the files to open?
I'm using MS Excel 2007. When I try to "open with" Excel doesn't come up as one of the options.
Sorry for the trouble!
Zelda,
When I save the file to to my computer, it saves & therefore opens as a winzip file, with many files within
I am not sure why it saves as a zip file. Here it saves as a xlsm file.
Try changing file name to Getting-things-done-template-v1.xlsm
Thanks Oscar. I tried your idea: changing file name to Getting-things-done-template-v1.xlsm, with the same result. I also tried .xls...same.
It's ok. I'll keep looking.