|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 8th 12, 01:31 PM
|
|||
|
|||
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 
|
| Ads |
|
#2
July 8th 12, 03:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking data from one worksheet to another using ookup functions
On 8/07/2012 10:31 PM, Sher10 wrote:
> 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 > > > > Actually I don't see anything on the "Roster" Sheet as you have not linked it. Try using a file sharing site similar to ExcelBanter or alike then re-post the link here. Cheers Mick.
|
|
#3
July 8th 12, 03:52 PM
|
|||
|
|||
|
Quote:
Perhaps if you attach the example workbook we can see what you mean and help... S.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking data from one worksheet to another... | hrquestions | Excel Worksheet Functions | 2 | May 6th 10 12:55 AM |
| Linking worksheet data | Glenn Dulmage | Links and Linking in Excel | 1 | August 11th 08 08:36 AM |
| Linking worksheet data | jra1031 | Excel Worksheet Functions | 4 | March 1st 08 09:53 PM |
| can I name an excel worksheet tab by linking to worksheet data? | jasarussell | Excel Worksheet Functions | 2 | April 12th 06 11:34 AM |
| Linking worksheet functions and arrays - Doozie | gsimmons2005 | Excel Discussion (Misc queries) | 1 | August 17th 05 10:32 PM |
Linear Mode
