Forum Discussion

SMElectrical's avatar
SMElectrical
Copper Contributor
Jun 20, 2024

Excel Macro coding help

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

  • lolpolpro's avatar
    lolpolpro
    Copper Contributor
    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)
    • SMElectrical's avatar
      SMElectrical
      Copper Contributor
      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.

Resources