Scheduling formula - If this criteria is met, copy cell text to a different page

[luke4swimming]

Hello! I am needing help with probably a simply scheduling formula. I have a 2 week "master" schedule on the first page and then "daily" schedules on the pages following.

I am wanting the daily schedules to pull info from the "master."

For example:
On page 2 "Daily 1" - F7 is filled - from page 1 "2 week master" section A19:AE27, A7 of page 2 "Daily1" matches page 1 "2 week master" B19:27 & C19:C27, Copy D25 and E25 page 1 "2 week master" to page 2 "daily 1" F7 & G7

Not sure if I explained that well enough, so please let me know if you have any questions.

[Squeaky]

If I understand this correctly, Daily 1 is Sunday, Daily 2 is Monday, etc. You have a simple cell to cell mapping going on here. On the Daily 1 sheet, in cell B5, you will need the formula
='2 Week Master'!D3 In all of the other cells simply use the same formula and change D3 to equal the needed cell on the '2 Week Master' page.
On the Master, John Smith, A-Wing Nurse from 6:30am-7pm is in cell D11. So cell D5 on the Daily 1 sheet corresponds to that same description so the formula ='2 Week Master'!D11 will pull that information.
You will need to map all the target cells in this manner. Playing with your form I noticed the tendency for the form to "auto-fill" that formula erroneously down the column when you hit enter.
Hitting control-z right after you hit enter should undo the auto-fill and leave you with the formula you entered.
On the master sheet you may want to fully populate every cell with numbers so you can make sure they are going to the right place, then delete them afterwards.

Good Luck.

Squeaky