Results 1 to 2 of 2

Combine Data from Multiple Excel Files in a Single Excel Sheet

Threaded View

  1. 04-06-2022, 11:22 AM #2
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    24,016

    Re: Combine Data from Multiple Excel Files in a Single Excel Sheet

    I did a simple append and it seems to have arranged the data correctly, but I am not sure. Suggest you review the results and see if this worked for you.
    Attached Files Attached Files
    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
« 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. Combine multiple Excel files into 1 Sheet
    By stoqnowm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2021, 04:28 PM
  2. Combine Excel files into Single sheet (values only) add column for filename
    By supremesabre in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2017, 11:48 AM
  3. [SOLVED] Import named sheet from multiple excel files into a single sheet in defined excel file
    By LovesEurope in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-16-2016, 10:45 AM
  4. combine data from multiple files/sheets into single sheet and label with file/sheet name
    By cwyn in forum Excel General
    Replies: 0
    Last Post: 10-12-2015, 10:02 AM
  5. [SOLVED] Combine data of some cells in multiple excel files into one sheet
    By ricdamiani in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-07-2013, 12:07 AM
  6. How to consolidate data from multiple excel files into single sheet in new book?
    By Pradeep M B in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2013, 09:37 AM
  7. Search multiple excel files in several folders; find string; copy data to a single sheet
    By wesrockin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 12:05 AM

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