Copy the data in sheet 1 of excel A to sheet 1 of excel B [Closed]

Report
-
Hello,

I want to copy the data in sheet 1 of spreadsheet A to sheet 1 of spreadsheet B on clicking the update button in spreadsheet B

Ex:

Sheet 1 in spreadsheet A
Name Class Section Place
Jake 12 A Bangalore
Jill 12 B Bangalore
John 10 A Bangalore
Jhon 15 C Bangalore

The above data has to be copied to sheet 1 of spreadsheet B on click of update button in spreadsheet B.

Say again in sheet 1 of spreadsheet A, if the data increases and becomes as below

Name Class Section Place
Jake 12 A Bangalore
Jill 12 B Bangalore
John 10 A Bangalore
Jhon 15 C Bangalore
David 16 D Mangalore
Mark 15 C Chennai

So, on click of update button, the above data should be present in sheet 1 of spreadsheet B.
Please provide me the macro/code to achieve this.

Thanks in advance
Nithin

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!