| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linking data from one worksheet to another using ookup functions
Hello Excel Experts,
I have a roster system and I want to link it to a timesheet. Meaning if Employee 1 is Rostered to work Monday then I want the start time to copy to the start time of Employee 1's timesheet. In the Roster I have all employees names in a data verification list The employees names range from A4:A11 and the Start times range from B4:B11 On the "ROSTER" Sheet, you will see that "Jo" has been rostered to start Monday at 10:00am. I want that information to copy to "Emp 1" sheet at G22. Please help, I know there is a way to do this. Thankyou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking data from one worksheet to another... | Excel Worksheet Functions | |||
| Linking worksheet data | Links and Linking in Excel | |||
| Linking worksheet data | Excel Worksheet Functions | |||
| can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
| Linking worksheet functions and arrays - Doozie | Excel Discussion (Misc queries) | |||
Threaded Mode
