+ Reply to Thread
Results 1 to 2 of 2

Combining multiple tables into one table

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    365 ProPlus
    Posts
    44

    Combining multiple tables into one table

    I have an excel document with multiple worksheets. The excel doc represents one "region" and each worksheet within it contains data (revenue, tenants, etc.) on a different "property" within that "region". For each worksheet that represents a property, there is a also a table that is based off of the property information with information on the % revenue, % area, etc for that property.

    What I want to be able to do is take each of these tables from the different worksheets and combine them into one large table that represents the entire region.

    I have attached a sample document with more text going into further detail.

    Bottom line, I want to know if there is a way to combine separate tables (that take information from a set of data) and combine those tables into one large table.

    Any help is greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Combining multiple tables into one table

    Make sure that your sub tables are in the IDENTICAL cell ranges on each sheet (the table for Property 1 starts one row up from the others) and then fill your summary table with formulas like

    =SUM('Property 1:Property 4'!P47)


    where appropriate, and then calculate the other metrics based on those sums. (for example, don't sum the percentages - calculate those from the summed values....)

    If you have a lot of sheets, just make sure that you use =SUM('First sheet name:Last Sheet Name'!Cell address) - these are 3D formulas, explained here:

    https://support.office.com/en-us/art...ad=US&fromAR=1
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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: 1
    Last Post: 02-26-2016, 12:05 PM
  2. Combining Multiple Tables in one worksheet into One Table
    By rhiminee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2013, 11:06 AM
  3. Combining multiple access tables
    By terreese in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 AM
  4. Combining tables into one pivot table
    By doubl3d80 in forum Excel General
    Replies: 0
    Last Post: 03-20-2012, 01:35 PM
  5. Combining two tables to produce new table with unique records
    By thales in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2012, 04:47 AM
  6. Replies: 2
    Last Post: 02-02-2012, 09:49 AM
  7. Combining Multiple Tables
    By fervorking in forum Access Tables & Databases
    Replies: 4
    Last Post: 06-24-2011, 10:44 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1