You didn't say what part (range) of your data you wanted to put into the
list for the drop-down cell. If you want A4:A30, name that range say,
TheList. Then go to the cell in which you want to put the drop-down and
click on Data - Validation. Select List. In the Source block type
"TheList" without the quotes. That's it. HTH Otto
"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,