(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:
This code goes in the bit for the user form:
Edit - hopefully the example file is also now attached. The Google drive link above is because the other forum doesn't allow file uploads.
Bookmarks