I'm not sure how to describe what I need so I'm having trouble searching for it. Perhaps someone will know what I'm talking about by reading this? I'd really appreciate any help:
I have a spreadsheet that is basically a schedule of availability for several employees. This spreadsheet is used to schedule each person to participate in a project twice a month.
I have a seperate tab for each day of the month that has specifice info on the project they have been scheduled to complete. What I would like to do is have excel grab the name of the individual if I indicate on their row of availability that they are being scheduled and then automatically pull the name and populates it into the tab corosponding to the day they were scheduled.
Well there it is. Not sure if it makes sense but I thought I'd throw it out there and see what happens.
thanks!
Bookmarks