Hello,
I would need help with a project management in excel. I'm including jpeg which explains it better .Included jpeg is from kingsoft, but it works the same as excel. I have excel 2010 at work.
1. I would like to have a view of 2 windows in a split view at the same time .
My top window has TASKS list and details, but its is just one line for one task.
2.In my bottom window I would like to have specific tasks name with additional comments.
Multiple lines per task.
===A specific task from top window would appear in the bottom window ,if a cell from column A top window is activated.
-Example: IF you Click on A2 top window THEN task name from A2 appears in bottom window A2 with all the comments,flies,details,problem .
-Example:.IF you Click on A3 top window THEN task name from A3 appears in bottom window A2 with all the comments,flies,details,problem
I have around 300 tasks ,at any given time,which are updated daily.
Thank you for your help.
Bookmarks