Pulling data from another workbook.

Hello. I have Workbook A with two tables: Tbl1 and Tbl2, and many other things..
I want to pull the data from Tbl1, and put it in Workbook B.

I know there are two solution:
1. I use cell reference to refer each and every cell in Tbl1 in Workbook A.
2. Create an excel connection, then it will copy ALL DATA from Workbook A, to put in Workbook B. That is not what I want.

Which solution is the proper way to do this task? As you can see, in Workbook2, manual_link sheet, the data I want looks very neat! While the other sheet with excel data connection, it is really a mess!

Thank you Mike. So what is the main function of excel data connection?
To my understanding, excel connection just blindedly copy all text data from one worksheet, to another sheet on another workbook, and I will loose all the talbe and format.
If you must copy data from one workbook, to another workbook. What is the best way that you will do? Using VBA to copy, or using the cell link that I have done above?

@FDibbins: So basically I must miror each and every cells in WB2 if I want to copy from WB1?
Is there anything like this in workbook 2:
=[WbookA][Sheet]!Table_name_that_I_want

Thank you.
The problem is, I regularly got the raw data from 3rd party, and I don't know how many rows they have. Anyway, direct referrence to each and every cells is not a bad choice.

Originally Posted by gaixixon

Thank you.
The problem is, I regularly got the raw data from 3rd party, and I don't know how many rows they have. Anyway, direct referrence to each and every cells is not a bad choice.

ok ok, this is what you do; just copy and paste this code; into a macro called dRetriever

Please Login or Register  to view this content.