johneva Posted May 5, 2006 Share Posted May 5, 2006 HiThis 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.xlsRight have got table for each day of the week with the Drivers name in col APayroll No. in col BShift number in col CThen the hours of the shift in col DIt 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 More sharing options...
discarnet Posted May 12, 2006 Share Posted May 12, 2006 would love to help you but i can't get the link you provided to work, I to work in a transport office and am working on a sheet for on a simular thyme Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now