problem in macro recording copy and paste in new excel file,

**vengatvj** · 11-06-2013, 09:09 AM

i have a excel file with two sheet, i want copy sheet 1 and sheet 2 data to new excel file, sheet 1 data paste in sheet 1 and sheet 2,
how to make in vba?

i tired it macro recording , not working
see sample file..

**alansidman** · 11-06-2013, 09:12 AM

Why do you need to copy and paste to a new workbook? Why not just save it with a new workbook name. Now you have two workbooks exactly the same.

Additionally, you have not provided us with any code showing what your code is doing or not doing.

**vengatvj** · 11-06-2013, 09:20 AM

Please Login or Register  to view this content.

To tell you the fact i have a excel with multiple sheet, all data's are very sensitive, i cant submit my original excel to my leader, just i want copy particular two sheet data's to new excel file and save in sheet 1 and sheet 2, its very simple work, but i want know how to copy and paste in new excel, if i know i will use for another one use..,