+ Reply to Thread
Results 1 to 5 of 5

Multiple Workbooks to one 'Master Workbook'

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Red face Multiple Workbooks to one 'Master Workbook'

    Hi all,

    I would like to be able to auto transfer Cols A & B from multiple workbooks to one main Master Workbook (again just to Cols A & B).

    Is this possible?

    Complete dummies guide would be required I think....err...make that for certain.

    Thanks
    Hammer

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

    Re: Multiple Workbooks to one 'Master Workbook'

    Without using code, try this simple option...

    1. open your master and at least 1 of the other sheets
    2. in master, select the cell where you want the "answer" to be, and type =
    3. click on the other workbook, select the cell you want, and press enter
    If the other WB names are similar to the 1st "other" WB, you can copy the formula you just created to where you want it, and adjust the file name accordingly
    4. delete any absoulute references you see in the formula ($), and copy down as far as you need
    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

  3. #3
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Multiple Workbooks to one 'Master Workbook'

    Hi FDibbins, thanks for your reply.
    Thought I better show some of the other workbook names and examples of the info in each:

    Workbook name:

    BAK BEST BDH1.csv


    Col A Col B
    4/03/2011 JACOBS SON(GB)
    9/03/2011 ALLANIT(GER)
    10/03/2011 SUNLEY PEACE(GB)

    Workbook name:
    BAK BETS1.csv

    Col A Col B
    2/03/2011 INVINCIBILITY(IRE)
    5/03/2011 POKFULHAM(IRE)
    14/03/2011 ADVANCEMENT(GB)


    I need every cell from both Workbook/Cols input into the Master Workbook Cols A & B.

    Could you show me the exact formula for this please.

    Thanks
    Hammer

  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
    50,787

    Re: Multiple Workbooks to one 'Master Workbook'

    hmm you didnt mention that the files you are getting your data from where not other excel workbooks. The only way (that i know) to get .csv data into excel is to import it. Once you get the info into excel, if the data is in another WB, try this formula in your master sheet...

    ='[worksheet_name.xlsx]sheet1'!$A$1
    Altho, it will be easier to just type =, point to the required data and then press enter

  5. #5
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Re: Multiple Workbooks to one 'Master Workbook'

    I can save the csv files as excel files?
    Any other ideas folks?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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