Ok here is the situation:
I have two workbooks, each have one sheet.
One workbook is a list of jobs that contains a few columns mainly contact info. The other is a list of people that contains the names and the dates that they are available.
I am looking to be able to pull up the job and click a link that will provide me with a list of people that are currently available or will be available within the next 30 days.
We are presenting the jobs and want to pull up the people available to a large group of people and need to present it accordingly. The information is currently in Excel 97 so that is why I am posting it here.
So any help would be great. Also if there is a third party tool as well we would take that into consideration as well.
I hope that someone out there can help me.
Oneworld
I have two workbooks, each have one sheet.
One workbook is a list of jobs that contains a few columns mainly contact info. The other is a list of people that contains the names and the dates that they are available.
I am looking to be able to pull up the job and click a link that will provide me with a list of people that are currently available or will be available within the next 30 days.
We are presenting the jobs and want to pull up the people available to a large group of people and need to present it accordingly. The information is currently in Excel 97 so that is why I am posting it here.
So any help would be great. Also if there is a third party tool as well we would take that into consideration as well.
I hope that someone out there can help me.
Oneworld
