Code for cross checking sheets help

[masonutley]

Okay, I'll try to say this as clearly as I can because I confused myself with it. As you can see in the excel sheet below, there are 2 different pages. We have to do employee checks for each employee once a week and we mark it on our sheet to know which day. We notate it with a "^" in the E column on the "Sunday or Monday" page. Is there a code where we can put the ^ on the Checks page and have it show up on the E column. However, the same employee we put the ^ under might not be in the same spot as it always is. Thomas might be above Kayla under the Cashier AM, so is there a way for excel to check and then put it in their corresponding E column even if it changes.

See Kayla/Thomas for example of what I would like to happen. Notice how they are in different spots though. Just unsure if this is impossible or not. Also if there is no ^ or if we delete it then I would like for it to disappear on the Sunday/Monday page.

Someone please help!! This would be greatly appreciated. Thank you!

[shg]

Mason, would you be so kind as to take a few minutes to read the forum rules, and then amend your thread title accordingly?

Thanks.

[masonutley]

Sorry about that. Fixed. Didn't know what to really call the title because I don't know the name of what I'm looking for.

Someone please help though! Thank you.

[masonutley]

Not sure if I'm allowed to bump, but could someone please help? Or tell me if this is even possible so i don't keep checking back for responses? Thank you.

[shg]

You're certainly allowed to bump, Mason.

I think people are shying aways because it's just a hideous design (no offense) that will get continually worse as you try to do anything useful with it, and it's hard to see what you're trying to do now.

I would expect (Excel would expect) that you have a single sheet that looks maybe something like this:

Row\Col	A	B	C	D	E	F	G	H	I	J
1		7:00	10:00	12:00	14:00	16:00	18:00	20:00
2	Date	10:00	12:00	14:00	16:00	18:00	20:00	22:00		Employees
3	Mon 04/20/2015	Christian	Josh	Kayla	Noah	Terry	Thomas	Victor		Christian
4	Tue 04/21/2015									Josh
5	Wed 04/22/2015									Kayla
6	Thu 04/23/2015									Noah
7	Fri 04/24/2015									Terry
8	Sat 04/25/2015									Thomas
9	Sun 04/26/2015									Victor
10	Mon 04/27/2015									Viktor
11	Tue 04/28/2015
12	Wed 04/29/2015
13	Thu 04/30/2015
14	Fri 05/01/2015
15	Sat 05/02/2015

The employee list would serve as data validation for the entry for each shift. Where you go from there, I don't know -- it's way out of what I use Excel for.