The situation: I am trying to copy a set of cells 'A1 to F40' on a page called 'Confirmation & Shipping' in a macro, and make it paste and save on a separate new excel window.
The main problem is the pasting and saving on a separate sheet part.
I tried in VBA and have even tried in recording the macro myself.
Help me please! Much appreciated.