You must be logged in to purchase or download design files.
Not a member? Create an account.
This spreadsheet helps you to make sure that even the smallest detail
remains on the radar for your project or "to do" list. It allows you to set
a due date, person responsible, and add comments and status per items. The
spreadsheet automatically changes the status from unresolved to resolved
once a completion date is added for an item. This spreadsheet also features
push button functions to organize what you see on the screen such as
unresolved or resolved items only. It also allows you to sort the items
showing by due date to put the more urgent items on top of the list.
Macros let you automatically control what info displays, sort, and add new items to the list.
There are 8 reviews posted on this application.
“I've incorporated the changes mentioned here. I hope you like the revision”
“As a new member, this free download has helped me understand the basic framework for a spreadsheet for use by others. It was useful to access the underlying Macro/VBA code. I've already incorporated some of your techniques in my own spreadsheet. Regarding your spreadsheet, I see some opportunities for design improvement that I've implemented in my copy. Thanks!!”
“Great tool. A must have time and activity management tool. And on top of that, its free! Thanks a lot for the contribution.”
“Great piece of work here. Thanks for the contribution!”
“Love it”
“I am a procrastinator. Having this list has made me soooo efficient!! Love it! Thnks”
“One more thing, after the line
ActiveSheet.Paste
you might want to disable the paste function with this
Application.CutCopyMode = False
this will prevent possible accidental pasting.
You never know what people might do.
”
“People love to click buttons to see what they do. I would suggest you put a confirmation on the Insert Item Button to prevent having extra extra lines in your database. You might try using something like this:
Sub InsertRow()
'
' InsertRow Macro
Dim response1
Prompt = "Do you want to Insert a new Item Continue??"
response1 = MsgBox(Prompt, vbYesNo, "Insert a New Row")
If response1 = vbYes Then
Rows("6:6").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("g5").Select
Selection.Copy
Range("g6").Select
ActiveSheet.Paste
Range("A6").Select
End If
End Sub
Nice job though, I enjoy using it.........JoJo”