I've posted this question in another forum but with no luck so far. Here's to hoping someone here can help me work through this problem.
I'm trying to accomplish 4 different things with my spreadsheet.
The first two sheets in the workbook are job schedules (House A & House B). For each job, there are required tasks that have assigned dates, personnel and billing code.
The next sheet is the conflict report. I want this sheet to automatically return all conflicts with respect to personnel and/or billing codes. For instance, if a person is scheduled to work two or more tasks at the same time, I want to know it. I also want to know if a billing code is being used during the same time period. For the actual data output on this sheet, I would want to see the personnel and/or code along with the scheduled events that are causing the conflict.
The next three sheets are calendars. Each is a little different in terms of what I would like to see. For all three, I want to type in a date and have the calendar automatically update with the following 30 days (or however many will fit in the pre-determined size of the calendar).
For the project calendar, I want to see a rollup of all the jobs scheduled. Ideally, I would want it displayed as a color coded cell.
For the job calendar, I would like to have a drop down menu where I select which job I want to view (from all the available jobs - in the example it is House A and House B) and have the calendar display all the activities that are occuring during the time frame specified.
For the personnel calendar, I would like to have the option to select as many (or as few) personnel as I would like (from all available personnel) and have the calendar display all the days each individual is working. Again, this is probably best handled with color coding.
I realize this might not make much sense, so just let me know and I will hopefully clarify.
I'm trying to accomplish 4 different things with my spreadsheet.
The first two sheets in the workbook are job schedules (House A & House B). For each job, there are required tasks that have assigned dates, personnel and billing code.
The next sheet is the conflict report. I want this sheet to automatically return all conflicts with respect to personnel and/or billing codes. For instance, if a person is scheduled to work two or more tasks at the same time, I want to know it. I also want to know if a billing code is being used during the same time period. For the actual data output on this sheet, I would want to see the personnel and/or code along with the scheduled events that are causing the conflict.
The next three sheets are calendars. Each is a little different in terms of what I would like to see. For all three, I want to type in a date and have the calendar automatically update with the following 30 days (or however many will fit in the pre-determined size of the calendar).
For the project calendar, I want to see a rollup of all the jobs scheduled. Ideally, I would want it displayed as a color coded cell.
For the job calendar, I would like to have a drop down menu where I select which job I want to view (from all the available jobs - in the example it is House A and House B) and have the calendar display all the activities that are occuring during the time frame specified.
For the personnel calendar, I would like to have the option to select as many (or as few) personnel as I would like (from all available personnel) and have the calendar display all the days each individual is working. Again, this is probably best handled with color coding.
I realize this might not make much sense, so just let me know and I will hopefully clarify.