Forum Discussion
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? Tha...
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.
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.