multiple vaules from different sheets in one cell of another

D

deputy

im attempting to use excel 2000 to create a schedule for my department. The
idea is that there are multiple supervisors each with their own schedules.
There is also a monthly schedule that we want to show the assignments from
the seperate division schedules. Im looking for an equation that will allow
the monthly schedule to pull data from the division schedules. the amount
displayed on the monthly schedule should represent whatever information is
entered first in any of the division schedules. In other words... if Jane is
working for supervisor A, supervisor B will not be able to schedule her to
work for him... and the fact that Jane is working for supervisor A will be
displayed on the monthly schedule... i thank you for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract cell data from multiple files in one folder 3
Excel: Combine contents from identical cells on multiple sheets. 1
Deleting a Resource from a Resource Sheet 3
One-to-Many??? 1
Pull info from multiple worksheets into one Master 2
Scheduling/leveling a master project with multiple sub-projectsinserted (long read/questions) 4
Best way to pull data from several different sheets into a summary sheet 2
Showing data from one workbook in another. 0

Top