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.