Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple vaules from different sheets in one cell of another
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to take a number from the same cell in multiple sheets then a. | New Users to Excel | |||
How do I add (=Sum) the same cell for multiple sheets (103) | Excel Worksheet Functions | |||
Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
How do I change one cell across multiple sheets? | Excel Discussion (Misc queries) |