Formula or VBA to move content from another sheet

[Kelly Warden]

I have the following workbook below and need to move server names and times to sheet2 from sheet1 based on date/day of week. Only the highlighted cells needs to be moved over. This should change based on the date drop down at the top.

Any suggestions?

 

[NARAYANK991]

Hi Kelly ,

Can you please check back after a couple of hours ?

Narayan

 

[NARAYANK991]

Hi Kelly ,

See if this is OK. I have used a helper column so that you can understand the logic.

Narayan