Results 1 to 4 of 4

Consolidate data from different sheets in one sheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    7

    Consolidate data from different sheets in one sheet

    Hi,

    I have some data in 8-10 worksheets in all 20 excel file. I want to list this data on separate sheet in same file or separate excel file. I tried with ‘consolidate’ command but it didn’t worked for me.
    I want to list data appeared below 'Long Description (Size)' heading from all sheets in one sheet in same file or separate excel file.
    Please suggest solution for this problem. Sample excel file is attached here. Sheet names are not fixed.

    Reagrds,
    Pradeep S. Walse
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-07-2017, 10:01 AM
  2. Consolidate data from all sheets into one sheet
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2016, 09:01 PM
  3. How To Consolidate Data From Different Sheets to One Summary Sheet
    By Lawliet918 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-06-2015, 12:23 AM
  4. [SOLVED] Consolidate Data multiple sheets to a summary sheet
    By egchristensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2015, 02:04 PM
  5. Remove duplicats from 2+ sheets & consolidate data onto another sheet
    By akamenov88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2014, 12:50 PM
  6. [SOLVED] Consolidate data from multiple sheets into one sheet
    By adil.master in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-04-2013, 02:41 AM
  7. Need macro to consolidate data from different sheets to single sheet
    By sekharyadav in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2012, 03:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1