Hide Used Items in Drop Down List across multiple sheets

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.

Thanks Glenn,

Hi all,

Please find attached files.

One of the workbook called working example and the other workbook called what I would like to do.

Thanks,

Matthew.

Hi Glenn,

Thank you so much. I will have a look and see how I get on with it and how I can transfer to my main workbook using this.

Matthew.

Hi Glenn,

Have moved this to my main spreadsheet and it is working perfectly.

Thank you for your fast response.

Matthew.

Hi Glenn,

Have done for both.

Just a quick questions following on from the help you have given for this problem. I have another connected to it. Is this a new post of is it something you would be happy to look at.

Thanks,

Matthew.

Glenn,

How can you modify this to use in any column or cell?

It forces use in only C column. I am guessing it has something to do with the offset function in the define names?