+ Reply to Thread
Results 1 to 3 of 3

Best method to collect data from multiple sheets within multiple workbooks

  1. 01-16-2019, 12:45 PM #1
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Best method to collect data from multiple sheets within multiple workbooks

    Hi,

    I have 30+ workbooks all with 50+ sheets, all have the same structure
    What is the best way to collate the data for analysis

    Thanks
    Kevin
    Reply With QuoteRegister To Reply
  2. 01-16-2019, 12:47 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,755

    Re: Best method to collect data from multiple sheets within multiple workbooks

    You may want to look at Power Query for appending all data.

    HEre is a tutorial https://www.youtube.com/watch?v=a7E29H5ZUmE
    Last edited by alansidman; 01-16-2019 at 01:01 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 01-17-2019, 05:31 AM #3
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Best method to collect data from multiple sheets within multiple workbooks

    Very helpful.......Thanks

    Kevin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. collect data from merged cells in multiple workbooks to ecel sheet
    By thamara007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2015, 11:17 AM
  2. collect data from merged cells in multiple workbooks to ecel sheet
    By thamara007 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-09-2015, 11:14 AM
  3. macro to collect data from multiple sheets to main page and need to add the sheet name
    By lenin.gce in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2014, 09:27 AM
  4. Collect data from multiple sheets
    By xe-dingo in forum Excel General
    Replies: 2
    Last Post: 09-22-2014, 02:38 PM
  5. Macro to collect data from multiple closed spread sheets.
    By Awangkualizul in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2013, 08:27 AM
  6. [SOLVED] Collect data from multiple sheets into a Summary Sheet
    By Fuhgawz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2012, 12:56 PM
  7. [SOLVED] Macro to reorganize and collect data from multiple workbooks
    By bobfor1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2012, 01:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1