Automatic Macro required to copy and paste

Madhav_147 Posts 1 Registration date Wednesday June 21, 2017 Status Member Last seen June 21, 2017 - Jun 21, 2017 at 07:35 AM
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.