Copying worksheets to another workbook using macros

[John1989]

Hello all,
I have two excel work books namely 'Schools.xlsx' and 'colleges.xlsx'.

Both excels workbooks have 4 worksheets namely 'Science', 'Maths', 'English' and 'General'.

I have to copy the entire contents in Worksheet 'Science' in 'Schools.xlsx' and paste it in Worksheet 'Science' in 'Colleges.xlsx' using macro.

In the same way i have to copy 'Maths' in 'Schools.xlsx' and Paste it to 'Maths' in 'Colleges.xlsx'

Same steps for other two worksheets.

All i need is, I have to do this using a macro

Kindly help.

Thanks in advance

Johnson

 

[footoo]

Try creating a macro via the macro recorder.

 

[John1989]

Try creating a macro via the macro recorder.

Thanks for the reply
I am familiar with excel options but have only little knowledge in macro

Kindly help me

 

[footoo]

A good way to start gaining some knowledge about macros is to start using the macro recorder.

(Your original post has insufficient information to write a macro. For example, should the data be pasted to the next available row in the destination sheets, or should any data in the destination sheets be cleared before pasting the source data?)