+ Reply to Thread
Results 1 to 4 of 4

Populate data from specific range in multiple tabs into one master tab

  1. 08-09-2018, 04:13 PM #1
    jess2293
    jess2293 is offline
    Registered User
    Join Date
    08-09-2018
    Location
    Savannah, GA
    MS-Off Ver
    Office 2016
    Posts
    1

    Question Populate data from specific range in multiple tabs into one master tab

    I am trying to keep a weekly log of rail cars trans-loaded for my company. I have a tab for each week, and i'd like that data from those weekly tabs to populate over into a monthly tab. I have tried a few formulas, but i've had no luck

    The data I would like to copy from my weekly tabs is in cell range J:M of each tab (formatted exactly the same). I need the data from each of the weekly tabs to populate into cells A:D of the monthly tab. How can I make that populate so that I only have to input the data into the weekly tabs?

    I can get the data to populate over, but it required me to add that formula every time I want to copy data, that is very time consuming.
    Reply With QuoteRegister To Reply
  2. 08-09-2018, 04:18 PM #2
    Mvaldesi
    Mvaldesi is offline
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Re: Populate data from specific range in multiple tabs into one master tab

    Welcome to the forum!

    It'll help others help you if you can upload an example of your workbook with data desensitized and your desired results manually mocked up.
    Reply With QuoteRegister To Reply
  3. 08-09-2018, 04:23 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Populate data from specific range in multiple tabs into one master tab

    Hi, welcome to the forum

    Quote Originally Posted by jess2293 View Post
    ...I have a tab for each week.....
    This is a common error many users make. Unless there is a compelling reason to have each week on it's own sheet, it would be far better to have ALL data on 1 sheet, then pull any summaries/extracts/etc from that sheet. It smplifies all sorts of things.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 08-09-2018, 04:33 PM #4
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Populate data from specific range in multiple tabs into one master tab

    What Ford said. If you have all the daily data in one place, then you can parcel it out into weekly, daily or whatever buckets you want.

    Furthermore, if you have it organized correctly, you can do the work with pivot tables which figures out how much data you have and group it together without or with minimal use of formulas.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    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. How to generate a master list of all names and other data from multiple tabs
    By Scott.Applewhite in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-26-2017, 08:23 PM
  2. Summing columns of variable range in multiple tabs and collating them into a master sheet
    By CircusClown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 07:05 AM
  3. Array formula? Populate tabs based on Master tab
    By MjRmatt in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-18-2013, 07:58 AM
  4. [SOLVED] Populate multiple tabs based on input in Master tab?
    By MjRmatt in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 06:07 AM
  5. [SOLVED] Populate master sheet from data on multiple sheets
    By jhammond10 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-05-2013, 01:36 PM
  6. Share data from multiple worksheet tabs to a master tab
    By skeemo in forum Excel General
    Replies: 1
    Last Post: 07-20-2012, 07:51 AM
  7. how to auto populate data from multiple sheets to a master
    By Fosachy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2009, 06:15 PM

Tags for this Thread

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