Hi all,

I am stuck on a data drop down list that hides items once chosen.

I have read lots of different version on how to do this and found this one shown in the link to work great for me. Can not post link properly as I am new. Hope you can access still. I have just taken out the full stops.

www contextures com xlDataVal03.html

Currently I have one sheet (employees) with the list of names on it and on another sheet (schedule) I have it set up to enter the data into. All working great.

However what I would like to do (not sure if possible) is to have the drop down list on multiple sheets and it hides the items used.

Therefore:-

Sheet1 – Named Schedule 1 – Pick from drop down
Sheet2 – Named Schedule 2 – Pick from drop down however with name removed already in Schedule 1
Sheet3 – Named Schedule 3 – Pick from drop down however with name removed already in Schedule 1 and Schedule 2
Sheet4 – Named Schedule 4 – Pick from drop down however with name removed already in Schedule 1 and Schedule 2 and Schedule 3

Would like to do this for up to 6 different sheets.

I have tried to move the drop down to another sheets, however it works if you choose of the list in order and not random like the example in Contextures.

Hope that makes sense, thanks for any help you can give even if it is another way.

Thanks,

Matthew.