+ Reply to Thread
Results 1 to 2 of 2

MERGE and SORT several sheets with identical headers.

  1. #1
    Registered User
    Join Date
    05-21-2020
    Location
    Miami, Florida
    MS-Off Ver
    365
    Posts
    1

    MERGE and SORT several sheets with identical headers.

    I have several sheets with identical headers. I want to display their content on a separate sheet by a custom SORT.
    I am using Excel Office 365

    In Google Sheets is pretty simple:
    =SORT({SHEET1!A2:D100;SHEET2!A2:D100;SHEET3!A2:D100},3,1)

    Your help is greatly appreciated.
    Last edited by 4ero; 05-21-2020 at 08:36 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: MERGE and SORT several sheets with identical headers.

    Please read the yellow banner at the top of this page on how to attach a file.
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-09-2017, 04:55 PM
  2. [SOLVED] vba code to merge headers from 2 sheets at their specific columns position 3rd sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 11:41 PM
  3. [SOLVED] Code to sort Identical Headings in Different Sheets
    By hammer2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2016, 05:19 AM
  4. Replies: 5
    Last Post: 08-11-2015, 02:47 PM
  5. why cant i get identical sort from identical code
    By jimb0693 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2010, 01:04 PM
  6. VBA to merge multiple Workbooks with multiple sheets retaining headers
    By LauraN1 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-19-2010, 03:47 PM
  7. Replies: 0
    Last Post: 03-10-2010, 01:25 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