Excel calendar and schedule board

[roptics314]

Hello All,

I am trying to create an auto updating schedule tool. I have a table that has Row1 with times 8am to 8pm and then columns have staff and then dates. I want to check a cell against todays date. If it equals the date then it will copy the contents of the cell. If thedate does not equl then it checks the date of the next column.

Ex. Cell B5 checks cell G2 if TODAY()= the date in G2 then the contents of G5 get copied into B5. If the date is not correct then B5 checks H2 and if the date matches the contents of H5 are copied into B5 etc...

This is a status board so I can see 20 users covering phones, chat, lab.

I can't figure out how to get the cell to keep checking the columns until it finds the correct date.

Thanks,

Robert

http://www.dropbox.com/l/WHbHG2omONHZnqOVrTqjmc

 

[RJPotts]

What is in G2? G5? H2?

Best regards
Richard

 

[roptics314]

Hello,

Thanks for the reply.

Sorry I messed up. Row 1 has the dates so the active cell is checking G1 to see if the date = TODAY() and if it is then it copies the corresponding cell. X = out, PH = phone, CH = chat etc.

Thanks,

Robert