Help with a userform to enter data into cells in a matched row

I have a user form that enters basic inventory data into the first open row.
Column A is the bin location that I want to never change.
Columns B – F are where the userform data is put in.
Columns G-J contain information on what Contents will fit in the corresponding bin location in Column A.

I need to put the data from the userform into the first open bin location (A)row in the cells (B-F).

I need a code that will match the “contents” text typed into the user form with one of the placement columns (G-J) and put it into the first matching bin location (A) that is empty.

If there are no open cells, I would like a text message saying “There are no open locations”.

I have it partly mapped out, but can’t figure out the code. I’ve attached a sample of my worksheets. Thanks for any help you can provide.

just to make sure i understand, the user will enter information into the form, the Contents field will match one of the rows in column G-H, so the macro should go row, by row, looking for an empty one, when it finds an empty row check in the contents entered matches one of the contents fields, if yes, fill data B-F

correct?

im sure the solution provided by nilem will work, but since i was already writing it:

Please Login or Register  to view this content.