![]() |
|
#1
|
|||
|
|||
![]()
I have attached a working copy with all sensitive information removed.
I had to delete several tabs/worksheets in order to get this file to attach, so ultimately the calculations will need to encompass several more tabs. Everything from Column "N" and on are changes I made. Column "N" is where I'm pulling out unique incident types. Column "O" are totals for each incident type. Column "P" is where I'm pulling unique cities out (the color of the font was changed so the user doesn't see these items as I thought it would be easier to look at the following column totals) Columns "Q" and on are totals for each incident type for each city. Now, I'm just pondering how I get the totals on the master sheet(s) for each city for all tabs, for each incident type. Everything I have done so far was done so that the spreadsheet can be dynamic and everything updates..... as new rows are added for a new incident. The individual using this when I'm done has basic skills so I need everything to be simple. So, if you have time to help me out that would be great. I'm going to be plugging away at this again today to see what I can come up with. I started doing a pivot table but so far it's not working and Excel crashed a few times when I tried it for some reason. Uggggggg. |
#2
|
|||
|
|||
![]()
One additional note......
If I can find a way to search through columns "Q" through "AQ", look at row 1 and determine which column relates to a particular city then I could make a formula to go through each tab/worksheet and add up the totals for each incident type. Well, I would also need to publish all incident types as well so I guess this could also be a bit tricky..........once again, I defer to an expert where my skills are limited on Excel. |
#3
|
|||
|
|||
![]() Quote:
Quote:
Furthermore, I would forgo splitting the tables further with the "case review" partitions and add another date field for when a case review is complete. Quote:
To me, it looks like you are doing contortions to make the square peg that is this person's cobbled sheet fit into the round hole that is robust Excel design. IMHO, a tear down is begging to be made. If there's any chance you think my suggestions might work, let me know and I'll gin up something from this for you. I hesitate to proceed if there is some important reason for your partition by investigator. It will take me an hour or so to come up with the first cut. If not, I'll gladly whip something up. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
![]() |
veedee | Excel | 1 | 06-11-2014 04:01 AM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
![]() |
nolesca | Excel | 4 | 06-07-2010 08:13 AM |