Can anyone show me how I can copy 2 specific worksheets to a new workbook but without the macros attached to them?
I can copy a sheet to a new workbook fine, I can rename the sheet fine, but I'm struggling to do it with 2 sheets. This is what I have so far which works fine for 1 sheet...