I assume there's specific values you want them to select.
Depending on the options you'ra talking about, you could probably just yuse
data validation
Data-Validation
If you have a helper column with the list of allowed items, you can select
these as your source range, and if thevendor attempts any other values, wil
not alow entry...

"Neil" wrote:

I have vendors supply me with information about their merchandise to be
loaded into my host. On that spread sheet are many required fields. What I
would like to do is if they provide a part number in Column A for any number
of rows I want them to be required to enter all of the required fields and
only the required text for all of the remaining columns.

I would appreciate some tips on how to do that.