Hello again.
I tried to edit the formula a little but couldn't make it work for some reason.
Perhaps because I'm not sure about some of it haha
So I uploaded the spreadsheet now that I finally have it at home.
one the first page you have operator numbers, in a table named operator.
on Mon, you have the column with a number 1 in, that represents a cross reference so the operator knows which station he/she is working on.
On the copy paste page, i'm trying to use the IF formula to display the operator number on that page.



It's all a little confusing.

Thanks to those who help though!

Attached Files

T1 A Shift Daily.xlsm (62.4 KB, 14 views)