Add to lookup table from user completed form

[tony7262]

Hi,

I need to create a macro that will take a form that a user fills in and add the information to a pre existing lookup table.

Attached is an example of what I am looking for and the basics are I would like the macro to use the Grouping to determine which column to add the category to (these are just the names I have used in the example) and then take the new category and replace the first time that the word 'Spare' appears in the lookup list.

I can get all the basics of finding the correct column/row etc just can't work out how to join it up and fill all the data in from the user completed form.

Thanks in advance,
Tony