Excel Macro coding help

[SMElectrical]

Im new on this platform and I am trying to set up a new Excel document where I can transfer rows from one table to another table if one column reads a particular word.

Can anyone help me?

Thanks in advance

[#2]

how do i get a ticket, its the only place i can write in this whole stupid website and i really need help (sorry for using your poste for that)

[#3]

@SMElectrical 

Please provide more detailed and specific information.

[#4]

I have 2 sheets with a table in each. I want to automatically copy over from table 1 to table 2 all the rows where column H reads ‘yes’. I want the macro to locate the next available line in the table to copy the data to and I want it in table form so that I can then filter the second table as and when I need to.

I hope this explains what I’m trying to achieve?

Thank you

I’d like to create a button on the sheet with table 1 to run the macro when I choose to run it.