Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Data in 2 Worksheets
Help !
I would like to have data that is automatically provided to be automatically filled in for each day that a person that works. On my new worksheet, I have a calendar with the date on top and the following on the bottom Tech Name (B4), Start Hour (C4) and End Hours (D4). I am currently using ='schedule'!B3, to get my data from another sheet. On another worksheet (Schedule) , I have Date(A3), Tech Name(B3), Start Hours(C3) and End Hours(D3). I want the Tech Name, Start Hours, and End Hours to be filled in automatically in my new worksheet. I hope this makes sense to all. Any help would be appreciated. Thanks Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to worksheets | Excel Worksheet Functions | |||
Does anyone know how to cross reference two worksheets | Excel Worksheet Functions | |||
Reference different worksheets | Excel Discussion (Misc queries) | |||
Merging data between worksheets using reference index? | Excel Worksheet Functions | |||
Summarizing Data across Worksheets using a single reference | Excel Worksheet Functions |