Forum Discussion
SMElectrical
Jun 20, 2024Copper Contributor
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
- lolpolproCopper Contributorhow 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.
- SMElectricalCopper ContributorI 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.