View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] matthew.eve@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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