VBA code to compare names entered in multiple sheets - Work Schedule

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new, I will do it for you today: https://www.mrexcel.com/board/thread...-list.1141522/.)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Alan - the OP is new here, so I've provided the link for him this time.

(Moderators: thanks for flagging the cross posting. As I'd already started replying on one forum, I'm posting this reply to both - hope that is ok.)

I've created a mini version to demonstrate - link here: https://drive.google.com/file/d/17hx...ew?usp=sharing Explanation and VBA are below

I've create two named ranges:
"Avail": Availability sheet, from B2 to the bottom right corner of data - i.e. including date headings/names
"Assign": Assignments sheet, from B2 to the bottom right corner of data - i.e. including date headings, but excluding anything before the first column containing names.

I've created user form PickName, with combo box AvailableNames and command button OkButton.

In the VB Editor, this code goes in the bit for the assignments sheet:

Please Login or Register  to view this content.

This code goes in the bit for the user form:

Please Login or Register  to view this content.

Edit - hopefully the example file is also now attached. The Google drive link above is because the other forum doesn't allow file uploads.