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...
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...
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...