• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gathering Data from multiple files

K

Kinoyo

New Member
Hello,

I am working on creating a report where I need to gather data from multiple workbooks. They are currently formatted using the built in subtotal feature (genius!). What I need to pull from the files are the subtotal numbers created and placed into very specific places on an excel template I created.


I have tested the vlookup formula, but it won't work for me because subtotals have repeating titles.


Does anyone have any suggestions?


Thanks
 
Hi ,


Can you give a specific example , with cell / column / sheet references , of which data you wish to transfer where ?


Narayan
 
You can use SQL within Excel to consolidate data from various files/worksheets


Refer:

http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/

http://chandoo.org/forums/topic/how-do-i-consolidate-several-tables-in-one-long-table
 
You must log in or register to reply here.
Back
Top