Create a macro which creates a workbook and copies rows to it

[jmatthews]

Hello, I am hoping someone can help me i have attached an example. I want to create to buttons on the start sheet to do almost the same thing. I want one to check column AJ for an X and created a new workbook and copy every row with an X into that workbook. I also want to have another one that does the exact same thing only with column AK. Would someone be able to help me with this PLEASE!!! thank you so much in advance for any guidance given.ook2.xlsx

[JBeaucaire]

This will extract all the "x" rows from column 36 (AJ) into a new workbook, you can add a Save routine to the end. Use this as a base for creating your macro for column 37.

Please Login or Register  to view this content.