Thread: Cross referencing functions

Hi all
I am new to the forums here and desperately need some help. I am somewhat of a novice with excel but seem to be able to get by for most things. I have been asked to come up with a spreadsheet at work to calculate schedule compliance I just cant get a few things to cross link. I basically need it to take what ever person I copy from 'actual log in log out'(purely just data to use for testing), paste it to 'log in log out', hit calculate. it auto generates time out at that point so i'm good there. I just also need it to cross reference that person with the schedules tab in case they are out of compliance on sign in, break,lunch etc. and for totals to be on compliance sheet. Any help would be awesome as I have been pullin my hair out for three days.