VBA - Add information to table

[ormerods]

I’m trying to create a macro to add a new row of information to a table, the table I need to add to will be defined by the product name + _F so if I select product1 from the drop down list the table to add to would be called product1_F. I just need to add the information to column A, the rest of the information in the table should fill down as normal.

I have attached an example of the layout so you can hopefully see what I am trying to achieve let me know if this does not make sense!

[nilem]

try it

Please Login or Register  to view this content.

[ormerods]

perfect, thanks.