macro to save excel shees

**Shradharani** · 12-04-2012, 10:03 AM

Hi
I need a macro to save few excel sheet.
My macro should work like –
It should open a new excel workbook and then copy “final sheet” contents in from sheet “For saving sheet” and then paste the same in new excel workbook and come to the sheet2 of new workbook "A1" cell and then save the file with the same as mentioned in "Column D" from excel file” “For saving sheet” . "example-"AR 1001-AP 1008 dtd 12042012".Like wise it should create different files as per contents mentioned in "Colum D" . for example for attached particular sheet when macro is running it should create 11 excel files. Is it possible?
Please find the attachment for reference.
Thanks and regards
Shradha

**arlu1201** · 12-04-2012, 10:16 AM

Should any data be changed in Sheet1 of the new workbooks?

Should the tab that is copied be named as "Final" as well?

Any reason why cell A1 of Sheet2 of the new workbook should be activated?