thanks paul, that fixed that. but now that i'm on the make, if I have my list
with different colour pattens, can I have the cell colour patten transferred
also?? how?

"Paul B" wrote:

Leon, you could use Data Validation for the drop down list, have a look here
for more information

http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Leon Sapper" <Leon wrote in message
...
Hi, This is my first try in a Discussion Group, so bear with me.

I have a range of cells, (C4:M26) in which I wish to put a staff members
initials into indervidual cells. The rows are different jobs and the
coloums
are the dates of the month. I have a list of staff initials in coloum A
(A4:A30).

Every time I try to make a list, I get a error message..."A list can not
overlap another list" and I can go no further.

Kind regards,