Jump to content

Check it off


Recommended Posts


This is not easy for me to explain so I have uploaded it to the server I use for my website so you can get a copy of the excel file.

http://www.john-eva.co.uk/PAY SHEET.xls

Right have got table for each day of the week with the

Drivers name in col A

Payroll No. in col B

Shift number in col C

Then the hours of the shift in col D

It all works fine when you enter the shift number at the min it looksup in the shifts 2 table for the hours and enters the hours in the shift hours column.

But what I would like is in the tables for the days when you have entered a shift number it either highlights the shift from the list in shifts covered or just removes the number form the list.

Hope this make sence and hope someone can help.

Cheers John

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...