+ Reply to Thread
Results 1 to 3 of 3

Making a summary chart sheet from multiple sheets each with changing numbers of entries

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    Nevada
    MS-Off Ver
    Office 2016
    Posts
    2

    Question Making a summary chart sheet from multiple sheets each with changing numbers of entries

    I have 12 sheets in a single workbook. Each sheet represents a county. Within each county are multiple sites (rows) with heading columns describing the site characteristics. Each sheet/county has identical headings. Over time, I add/subtract sites from various counties.

    I want to make a summary page (with identical heading columns to the other sheets) that pulls all the data from each site in each county, given that the number of sites in a county is dynamic and I will keep adding/subtracting sites. How would I accomplish this? Thank you for any suggestions!

    In the example, I'd like to figure out how to make the summary table automatically show all the sites, even when I change the number of sites in County1 for example.
    Attached Files Attached Files
    Last edited by deviltwin01; 06-22-2018 at 03:10 PM. Reason: added spreadsheet example

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Making a summary chart sheet from multiple sheets each with changing numbers of entrie

    Probably a good place to start would be to attach a desensitized version of your workbook and show us, by manually creating it, what your desired output is.

    BSB

  3. #3
    Registered User
    Join Date
    06-22-2018
    Location
    Nevada
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Making a summary chart sheet from multiple sheets each with changing numbers of entrie

    Quote Originally Posted by BadlySpelledBuoy View Post
    Probably a good place to start would be to attach a desensitized version of your workbook and show us, by manually creating it, what your desired output is.

    BSB
    Thank you, edited!

+ 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. Scenario Summary Across Multiple Sheets with changing cells
    By Alexander1983 in forum Excel General
    Replies: 1
    Last Post: 03-29-2018, 01:41 AM
  2. Replies: 8
    Last Post: 03-14-2017, 07:31 PM
  3. Replies: 2
    Last Post: 02-12-2017, 07:06 PM
  4. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  5. Create a summary from multiple sheets on a master/summary sheet
    By detribus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 08:04 PM
  6. Making a chart with Multiple Sheets
    By irishpaim in forum Excel General
    Replies: 4
    Last Post: 12-01-2010, 05:39 AM
  7. Summary sheet from recent entries in other sheets
    By harley87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 11:07 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