Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi again,,,, I work for a bus company and would like to link sheets in a
workbook I have list of duties on one sheet with times they start and end. Within another sheet, I have list of employees. What i would like is to link the sheet, with the duty numbers on and times they start and finish, which is named (Book On Times), with the sheet with the list of employees on, named (Staff Lookup), then finally linking this with another sheet within the workbook named (Duties Allocated) for instance:- If I input a duty number within the first column within the worksheet named (Duties Allocated), I would like all the rest of the information to be inputted automatically from the other sheets within the workbook..... If I input under the column named Duty No, the duty number 4, I would like the start and finish times of that specific duty, and also the name of the employee to be automatically inputted across the rest of the row.... sorry if I have got my rows and columns mixed up ( I think columns go down and rows go across the worksheet), any way thanks for any help that anyone can give -- Thanks for any help world.... xxxx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What if Dilemma | Excel Discussion (Misc queries) | |||
Apostrophe Dilemma | Excel Discussion (Misc queries) | |||
BIG Dilemma.....HELP!! | Excel Worksheet Functions | |||
If Then Dilemma | Excel Worksheet Functions | |||
Hyperlink Dilemma | Excel Discussion (Misc queries) |