amrinderminhas
New member
- Joined
- Mar 25, 2014
- Messages
- 12
- Reaction score
- 0
- Points
- 0
Hello everybody,
I would like to create scheduling system in excel sheet. The following picture is attached for explanation.
It should work as follows
I have to make a schedule of the chapters and their completion date.
The column A, B and C will be filled by me always. Lets say today is 4th aug 2015. So Now for Column E if the chapter's completion date is 28/07/15 which is passed then there should be written "pending by day 7", similarly for all cells. if date is yet to come or present date is there then in column E should be written "Date is due". This sheet should be daily updated by itself with respect to date mentioned in column C.
Now column D should show icon set as shown, more the time pending more the black moon, lesser the time pending lesser the black moon, done or due date should be represented by full white moon
Column F and G must have macro as shown. When i click "Done" then on the cell like on E2, E3, E4 etc. the text should change as shown in Column E depending upon on which date i clicked Done.
If Done is clicked on the date for completion then write "Done on due date",
if Done is clicked after the date of completion then write "Done .... days late" and
if Done is clicked before the date of completion then write "Done...... days earlier.
When i click Reset then again the text "pending by day...."should be re-written (erasing the text earlier in the corresponding cell E2, E3 and so on..
Anything else like to display the performance on chart will also be appreciated
Thank You, I will wait for your answer.....
I hope i make myself clear....
I would like to create scheduling system in excel sheet. The following picture is attached for explanation.
It should work as follows
I have to make a schedule of the chapters and their completion date.
The column A, B and C will be filled by me always. Lets say today is 4th aug 2015. So Now for Column E if the chapter's completion date is 28/07/15 which is passed then there should be written "pending by day 7", similarly for all cells. if date is yet to come or present date is there then in column E should be written "Date is due". This sheet should be daily updated by itself with respect to date mentioned in column C.
Now column D should show icon set as shown, more the time pending more the black moon, lesser the time pending lesser the black moon, done or due date should be represented by full white moon
Column F and G must have macro as shown. When i click "Done" then on the cell like on E2, E3, E4 etc. the text should change as shown in Column E depending upon on which date i clicked Done.
If Done is clicked on the date for completion then write "Done on due date",
if Done is clicked after the date of completion then write "Done .... days late" and
if Done is clicked before the date of completion then write "Done...... days earlier.
When i click Reset then again the text "pending by day...."should be re-written (erasing the text earlier in the corresponding cell E2, E3 and so on..
Anything else like to display the performance on chart will also be appreciated
Thank You, I will wait for your answer.....
I hope i make myself clear....
Last edited: