+ Reply to Thread
Results 1 to 3 of 3

Consolidating data from several tabs into one, side by side

  1. #1
    Registered User
    Join Date
    02-02-2021
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2016
    Posts
    2

    Consolidating data from several tabs into one, side by side

    Let's say you have a workbook with 50+ tabs, and you want to consolidate certain data from those tabs into a single tab at the front of the workbook (sheet1). But let's say you want to make the pulled data pull to the right, such that data from sheet 2 might populate column A, sheet 3 data might populate column B, and so on. But the data being pulled from each tab is in the same reference cell(s). Is there an easy way to do this?

  2. #2
    Registered User
    Join Date
    02-02-2021
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Consolidating data from several tabs into one, side by side

    no one? Buhler?

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Consolidating data from several tabs into one, side by side

    It would be easier to help if you can provide a sample file. You can carry out what your asking by using formulas, maybe you can use power query, or a VBA solution. It depends on your file.

+ 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. Align data in multiple sheets in a mastersheet side by side
    By sujit_sarkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2015, 02:40 AM
  2. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  3. [SOLVED] How to move data from right side to left side, please check the attachment
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2013, 03:43 AM
  4. How to open an Excel file with two tabs side by side
    By Aegwyn11 in forum Excel General
    Replies: 2
    Last Post: 11-27-2012, 12:50 PM
  5. Combine side-by-side data series with 3D column chart
    By isburns in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-04-2009, 04:15 AM
  6. View tabs side by side?
    By DaveH in forum Excel General
    Replies: 3
    Last Post: 05-04-2006, 11:40 PM
  7. Replies: 1
    Last Post: 03-20-2006, 10:15 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