Automatic Macro required to copy and paste [Closed]

Report
Posts
1
Registration date
Wednesday June 21, 2017
Status
Member
Last seen
June 21, 2017
-
Dear Sir,

I have one excel sheet where all data is save from A1 to F46 Cell. I want to copy this data from A1:A46 and paste it into new excel Sheet. This file should save automatic in particular folder with the Name in Cell no G1.Here my active workbook is tobe open and new file is tobe closed.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!