View Single Post
 
Old 11-07-2015, 12:01 PM
scorpain scorpain is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default

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
File Type: xlsm T1 A Shift Daily.xlsm (62.4 KB, 14 views)
Reply With Quote