User Form or Formula?

[Justinian]

I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name.

Would I use a user form or formula in order to accomplish this?

 

[Justinian]

Got it working now. Not sure why it did not work Friday but thank you for your help!

 

[Peter_SSs]

Got it working now. Not sure why it did not work Friday but thank you for your help!

Glad it worked out in the end. Thanks for letting us know.