Help on Excel Formula to AutoFill Details

Hi guys,

I would need some help regarding formula use in excel. I have attached my excel file in the thread, please do have a look.

Inside Sheet 1 I have a list of details which is not sorted. I do not wish to sort my data and leave it as per it is.

Next in Sheet 2, I have a table which is sort of a Schedule view in landscape. Its arranged according to the date/day. There are 2 zones divided by AM / PM. AM on the Top and PM on the bottom after the line.

May i know how can i code a formula to automatically fill in the the Name and Location in sheet 2, which is sorted according to the Date and Time where there are 2 zones.

I hope you guys can help me out on this. Thanks in Advance. I hope there isnt a need for VBA code. Thanks

Cheers!!