Need help transferring multiple cells on a conditional basis.

[Monty484]

Hi, great forum! I've been poking around for a few minutes and have already picked up a few tricks.

As a personal side project, I am attempting to simplify and update the way in which my Army unit schedules our daily flights. If you open the attached workbook, you will see that everything is driven by a one-stop shop page named 'Week Schedule'. In the future, I am going to add auto-populating forms required for each flight, however, in the meantime I would be content to just get the Form 5484 working correctly. As you can see for the fictional Monday schedule, the 5484 auto-populates with all the pertinent data and is (For the most part) working as I want it to. For Friday, however, I am trying something new: I'd like to send individual flights to two different 5484s based on whether the flight will fall under the AM or PM periods. You can probably tell my Excel skills are not exactly amazing! I've been barely squeaking by on what I was able to teach myself over the last few days and frankly, I've hit a wall. I can PULL information into a cell, but I'm a little lost in how to SEND it to one cell or another based on time.

Sorry if this is all confusing and thanks in advance for any help!

Flight Scheduler.xlsx

[dangelor]

Possibly if you precede your IF formulas to check if the time is <=0.5 for AM or >0.5 for PM...

=IF('Week Schedule'!F3<=0.5,IF('Week Schedule'!D3="","",'Week Schedule'!D3),"")