Hi

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


--
johneva
------------------------------------------------------------------------
johneva's Profile: http://www.excelforum.com/member.php...o&userid=34156
View this thread: http://www.excelforum.com/showthread...hreadid=539219

I take it that this is not easy or cannot even be done.

If I was not clear the first time I need to lookup numbers in one
column and if the nuber exists in that coloumn highlight it in a list
of numbers in another column.

Thanx John


--
johneva
------------------------------------------------------------------------
johneva's Profile: http://www.excelforum.com/member.php...o&userid=34156
View this thread: http://www.excelforum.com/showthread...hreadid=539219