andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
I am working on a project where I have list of tasks in column B. (This can be a few dozen or several hundred depending on what is going on) In columns C,D,E I have a 'key phrase' or 'value' assigned to each task. For example the first task is scheduling employee requests. I would put that in a category for 'schedules' and for 'management'. The categories could be represented by a number if that would be easier for Excel to recognize.
Now in Column F and G I would like to select the individual(s) assigned to the task. I was thinking of typing it in or selecting it from a drop down.
The tricky part here is that I have a separate sheet for each person, And I would like that info from the row where I selected or typed in the name to appear on that persons page.
The idea here is that I take my task list, however long, and select an individuals name and have that task appear on the individual page for that person. so that I don't have to copy and paste each task on 1 of 40 different pages.
The 'value' of each task isn't nearly as important as figuring out how to move the info from the main sheet to all the individual sheets. I hope this makes sense. And any help whatsoever would be greatly appreciated!
- Andrew
Now in Column F and G I would like to select the individual(s) assigned to the task. I was thinking of typing it in or selecting it from a drop down.
The tricky part here is that I have a separate sheet for each person, And I would like that info from the row where I selected or typed in the name to appear on that persons page.
The idea here is that I take my task list, however long, and select an individuals name and have that task appear on the individual page for that person. so that I don't have to copy and paste each task on 1 of 40 different pages.
The 'value' of each task isn't nearly as important as figuring out how to move the info from the main sheet to all the individual sheets. I hope this makes sense. And any help whatsoever would be greatly appreciated!
- Andrew
