roptics314
New Member
- Joined
- Mar 29, 2013
- Messages
- 2
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
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
Last edited: