modify exist macro to copy one more sheet data.

[sarat47]

Hello Everyone,

I have one template sheet with defined macro ("1_SetUp_FinalExcel_V10") which is mainly used to copy data from existed sheet (available in SAS folder) into template one, and then create the output.

i.e. copy data from existed sheet "Data" into "Data" of 1_SetUp_FinalExcel_V10
"search_criteria" into "search_criteria" of 1_SetUp_FinalExcel_V10.
"Narrative" into "Narrative" of 1_SetUp_FinalExcel_V10.

But the problem is that Output from sheet "Narrative is not being copied".

Can anyone help me how to update this macro.

While testing the macro, please create one folder name as "SAS" , within that copy the output sheet as "Exelon (01DEC2013-31DEC2013)".

Advance thanks for your help

[sarat47]

can anyone help me how to proceed.

I need to copy only the data from third sheet (narrative) into template for which I need modification in macro part. I made some change
but I am getting error as run time error 9 (subscript out of range).

Please Login or Register  to view this content.

I have added the above part to existing macro. Please check why it is not working

Please Login or Register  to view this content.