I'm looking for macro which will help me to copy all the sheets that contain "sheet name- Cart_" in active workbook and get separated into new workbooks with the file name same as sheet name.
Sample 1 File contains 5 sheets (including hidden)
Only 3 sheets contain "Cart_1"
Sheets That contain "cart_" should be exported into 3 new workbooks and saved in the specific folder.
Any help would be highly appreciated.