macro to copy data from one workbook to another on specific sheet

[Chetan Chauhan]

Hi

I have two workbook having 8 worksheet each. Every day I need to copy data from previous day worksheet and paste it on new workbook with same sheet name.

For example :-
Workbook1 is having sheet named aa, gg, tk .....
Workbook2 is having sheet named as same as Workbook 1

Now, I want macro to copy data from Workbook1, sheetname 'aa' and paste the same in workbook2 in sheet name 'aa' and likewise

Hope I am clear in explaining my problem

Any help please.

Thanks

[JBeaucaire]

Copy how much data. Every cell?

[paradise2sr]

Yeah,I am interested in this for answers .But no reply was there.Kindly reply taking into condition for copying every cells.

[JOHN H. DAVIS]

Why not saveas new workbook?

[paradise2sr]

I think it is an existing workbook and required in existing workbook rather than saving as new workbook .

[JOHN H. DAVIS]

Then perhaps Saveas the existing workbook.

[JBeaucaire]

Paradise, you seem to be collecting infractions, so I won't add another this time. I'm closing this thread as dead.

PLEASE read the forum rules. You should not post questions of your own in other's threads, even dead threads.
PLEASE read the forum rules you agreed to when you joined, the link in the menu bar above.


Then post your own question in your own thread with your own attached supporting document(s) to make it easy for others to assist you. Thanks.