Userform - complex idea

Afternoon all, I'm wondering if anyone could help me with a problem i've had all day (and to add insult to misery my PC keeps blue screening )

Basically I have a single sheet with four weeks (A,B,C and D - Across the top) with a list of Numbers that dont change (Col A) - but the names change with the corresponding weeks (A,B,C and D) This is the data.

BOOK.xls

Above is the file that i'm currently on about, i've reverted back to near the begining as the one I have is a real mess

*The idea* The user should, if at all possible(?) - Select the week in the form (A, B, C or D) and then select a duty - which should then bring up the name. I.e Selecting week "D" and duty 01FT501 should bring up D ROBERTS within the "Name" part of the userform.

The next part is where I had problems, below is a section "Replace" where the user could type another name (Example Joe Blogs) then hit the tick - to replace "D ROBERTS" with "Joe Blogs"

I'm not sure if the next part is possible, but the duplicate bit at the bottom was an idea so the user wouldnt have the same nice twice (Like a check) So for Example Z ONGOR is in twice 12SA770 + 12FT001 in "D" week - it would simply list if there was a duplicate

Sorry for rambling on!

Any help on this would be great as im totally stuck! Thanks! :beer: