Excel Macro coding help

Copper Contributor

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

3 Replies
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)


Please provide more detailed and specific information.

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.