Thank you so much for the replies. I appreciate the explanations as well.

Ok, so do I just highlight A2 and at the top input the code in the formula bar or do I have to do the vba F11? If my contractor lists has 20 names, do I just copy and paste the code but keep changing the number?

One more thing, when it shows A2:G50, what does G50 refer to?

Again, thank you so much for the help and info!!!!