• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Advice Help on Reports

K

KBColo50

New Member
Hi - basically I've got numerous spreadsheets in the same workbook. Each spreadsheet is a different state with all the counties in that state and various information in them. I want to be able to report on various items and was wondering should I create a dashboard, or pivot table, etc....For example, I want a report showing all the counties within a state sales by month, with other factors specified. Then I'd like to be able to change that criteria or have someone be able to click a button that will redo the report to reflect those changes they want to see.


I appreciate anyones input on this. Basically I don't know the best thing to do, and the first thing to do once I figure that out!
 
I guess I should be a little more clear. Every worksheet represents a different state. Every state has every county and all the housing data within. What I want to do is be able to have someone be able to push a button or click a drop down and be able to pick say Vermont and Kentucky and variables within each of those states and have it produce a report. Hopefully that makes sense.


Thanks everyone for your help....

:)
 
I was hoping someone would post on this request. I really need some help. Would someone please take the time to reply? I'd really appreciate it.
 
Good day KBColo50


Could you not turn your data into pivot tables and then use the filters that would be in the top row to filter the data as you need and then print table for your report
 
Hi KBColo50,


The best way to get help is either to post a sample file or answer-cross questions and Montrey's is still unanswered.


I agree with bobhoc, PTable is just perfect.


Regards,

Faseeh
 
I'm sorry I didn't reply to Montrey's question earlier. I'm a little overwhelmed right now. It's a lot of data. Basically I've got a workbook that has about 25 worksheets within it. Each of the worksheets represents a state and each state has every county within that state. Along with county information, I've got populations, text columns of miscellaneous notes, formatted date columns, etc.


I've read over the responses I did get and it seems the general consensus is to do a Pivot Table. Let me go ahead and try that and I will post my conclusions as soon as I do. I'd really like to get this done before Thanksgiving....that would be a relief. So thank you to all who responded and I'll keep ya posted!
 
You must log in or register to reply here.
Back
Top