I am starting to build a form that will help the user add three additional bits of information to the workbook.

I have named the three input boxes on the form fEngineMake, fEngineModel, and fHorsePower.

Sheet 1 already has a listing of the Engine Makes in column A (i.e. Caterpillar, Waukesha, etc.). Column B then lists the Caterpillar models, column C the Waukesha models, etc.

When the user inputs the make and model into the form, it should search for an existing make. If it finds the make, then it should add the inputted model into the appropriate column. It would be added to the very end of the that column.

However, if they enter a new make, then the make should be added to the first available row of column A and the model in the first cell of the first available column on sheet 1.


Tongue twister, I know. If you have any ideas, please help.