Reference Data in 2 Worksheets

M

matthew.eve

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE error add'g formulas 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
If Condition 4
Auto populate value from one task to another in MS PROJECT 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Calculate end date and time 1
If Condition 0
Tie additional cells to cell automatically updated 1

Top