I have the following file attached that I use to track my daily task.
I would like to automatize the file by adding some requirements through conditional formatting, data validation, vba etc..:
1-Once I enter an action (Column A, status should be automatically equal to Pending, I shouldn’t copy the row above but the information should be displayed automatically.
2-The same for Priority (Column B) which will be reported with 1 by default but can be manually modified if necessary.
3-If I enter a task, the Schedule Day (Column C) should be automatically displayed with the date when It was enter the task (ex: if I enter a task today the Schedule day should be equal to today).
I shouldn’t copy the above line it should be automatically displayed.
4-Once I enter 100% in completed (Column F) the effective date should be equal to the corresponding date when the 100% was entered and the status should be equal to Done:
Ex: I enter in line 2 task 1 then automatically:
The status should be equal to pending, the Schedule day should be equal to 28/09/15 or 09/28/15, priority equal to 1 Effective Day equal to blank and Completed equal to 0% the color conditional formatting should be kept.
Tomorrow I report in F1 100 then the Effective day should be equal to 29/09/15 or 09/29/15 the Status should be equal to Done. In the meantime I report Task 2 in line 3the status should be equal to pending the Schedule day should be equal to 29/09/15 or 09/29/15, priority equal to 1 Effective Day equal to blank and Completed equal to 0%.
What I want to avoid is to manually copy the formula from the above line I would like to apply this logic for all the lines once I have enter tasks in Column A.
If you have questions, please don't hesitate to contact me.
Thank you very much for your help.