I am fairly good with excel, however, I am having a lot of trouble trying to figure out a solution. This is my current problem.
I have two separate reports. The first report lists people and their available time per week.
The second report is a job report. It lists all the jobs and the hours per week each job requires.
What I am trying to do is come up with a macro or formula that will search to see who has the available time to fill a job and then return that name by each job.
So the availability report would look like this:
A1 - Persons Name
A2 - Job Title
A3 - First week
A4 - Second Week and so on
The job report would look like this
A1 - Job Name
A2 - Job Title
A3 - first week
A4 - Second Week and so on.
I would greatly appreciate anyones help on this, even if its just a step in the right direction!!
I have two separate reports. The first report lists people and their available time per week.
The second report is a job report. It lists all the jobs and the hours per week each job requires.
What I am trying to do is come up with a macro or formula that will search to see who has the available time to fill a job and then return that name by each job.
So the availability report would look like this:
A1 - Persons Name
A2 - Job Title
A3 - First week
A4 - Second Week and so on
The job report would look like this
A1 - Job Name
A2 - Job Title
A3 - first week
A4 - Second Week and so on.
I would greatly appreciate anyones help on this, even if its just a step in the right direction!!
