Macro for importing data from one excel book to another excel book...

[jaysakle]

Hi Friends....
Please guide....

1) I have two excel book "Book-1" and "Book-2"...
2) Book-1/Sheet-1 contains a table of six column and 100 rows with specific data mainly text....
3) I wish to import that table in "Book-2 / Sheet-1" as a normal table using a command button...

Thanks in advance.....

 

[Andrew Poulsom]

Welcome to MrExcel.

Record a macro while using Microsoft Query and assign it to your CommandButton:

Use Microsoft Query to retrieve external data - Excel - Office.com

 

[VoG]

Cross posted Macro for importing data from one excel book to another excel book...