kumaramitouj
10-21-2010, 04:32 AM
:banghead: Hi,
I have the following sheet where i am stuck, thru one of the code i found on this forum i a was able to reach 30% of the desired solution.I would be really greatful if any one can help me on this. I have prpeared a task list for my team, thru formulas relevant task gets populated on the relevant sheet, now what i want is when my team members update the relevant status, the same to be updated on the task sheet namely colum status + update.
Now with the earlier code it creates a new Sheet Master but is not giving me the desired result can anyone help me in:
1. when i press update instead of new sheet the existing Task sheet gets updated namely only the status and update column?
2. when the task is marked closed the same is deleted from the active task sheet and added to archive?
I have the following sheet where i am stuck, thru one of the code i found on this forum i a was able to reach 30% of the desired solution.I would be really greatful if any one can help me on this. I have prpeared a task list for my team, thru formulas relevant task gets populated on the relevant sheet, now what i want is when my team members update the relevant status, the same to be updated on the task sheet namely colum status + update.
Now with the earlier code it creates a new Sheet Master but is not giving me the desired result can anyone help me in:
1. when i press update instead of new sheet the existing Task sheet gets updated namely only the status and update column?
2. when the task is marked closed the same is deleted from the active task sheet and added to archive?