+ Reply to Thread
Results 1 to 8 of 8

Pulling data from another workbook.

  1. #1
    Registered User
    Join Date
    07-21-2015
    Location
    Earth
    MS-Off Ver
    2013
    Posts
    28

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Pulling data from another workbook.

    You could write some code to copy and paste it in and avoid the link all together, or you could have code run automatically when you open the workbook.
    Or you could keeo your simple links, and drag them down over time, and then delete the cells that are nonsense.

    Another option is to push the data into ACCESS then have your other sheet just refresh and pull in the data from access.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-21-2015
    Location
    Earth
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling data from another workbook.

    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?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,265

    Re: Pulling data from another workbook.

    from the table you had already created in book 2, I just created the normal link back to the 1st file. Because it is a table, it copied the formula down. Then I copied it across and changed the column heading
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    07-21-2015
    Location
    Earth
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling data from another workbook.

    @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

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Pulling data from another workbook.

    Quote Originally Posted by gaixixon View Post
    @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

    1) Yes, unfortunately.
    2) No, unforunately. Instead of having them in two workbooks, why not have them in one? You CAN have VBA automatically grab it and/or extend the table to the bottom of the data.

  7. #7
    Registered User
    Join Date
    07-21-2015
    Location
    Earth
    MS-Off Ver
    2013
    Posts
    28

    Re: Pulling data from another workbook.

    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.

  8. #8
    Registered User
    Join Date
    02-18-2015
    Location
    United States
    MS-Off Ver
    2013
    Posts
    25

    Re: Pulling data from another workbook.

    Quote Originally Posted by gaixixon View Post
    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pulling Data into One Workbook from Another Workbook that is Closed
    By Jams2114 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2015, 07:48 PM
  2. [SOLVED] cannot share workbook with macro pulling data from another workbook
    By Ramzes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2015, 10:32 AM
  3. Pulling data from one workbook with multiple tabs to another workbook.
    By manzier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2014, 03:41 PM
  4. pulling data from one workbook to a sheet of another workbook
    By deelauderdale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2010, 04:39 PM
  5. Replies: 5
    Last Post: 09-30-2008, 06:38 AM
  6. Replies: 3
    Last Post: 09-30-2008, 04:58 AM
  7. [SOLVED] Pulling data from another workbook
    By pdberger in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-12-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1