Hi guys,
Im currently constructing a project plan and was wondering whether someone here could help me out for a sec. I have a list of activities/tasks in Sheet A, which I use as an input sheet containing activity details, estimates etc. Activities are located in column A.
On another sheet B, I have a project plan where I can track progress of the activities using a gant chart (activities are listed in column A here as well).
My problem is that I'm not really sure how to make the activities in sheet B update as I add activities/task list in sheet A.
Example:
Sheet A- Column A - activities:
A1:Do laundry
A2: Clean the house
A3: Walk the dog
Lets say I want to add a task between A1 and A2 in sheet A (entry in italics);
A1:Do laundry
A2: Wash my car
A3: Clean the house
A4: Walk the dog
How can I have excel to insert a row in sheet B and update the list of activites here as well?
Hope everything is clear, thanks!
Have a great day.
Jacob
Bookmarks