Search results

I think they just like the idea of being able to see the drop-down items without actually having to click the drop-down, if that makes any sense.

Good points jeffreyweir. I would use DV, but my client doesn't like the format - making my job a lot more difficult. When I click on a State from the first list I want it to feed into a cell. I already have the VBA down for this, it's the same as Chandoo uses in many of his dashboards. I would...

Jeffreyweir, That is a similar post, but I didn't think they were similar enough to warrant a mention. I was using data validation and wanted to clear my previous entries. This time I don't want to use data validation due to its restrictions on displaying the list. (Thanks again for your...

Thank you for the quick responses. Maybe this sheet will help illustrate my point. https://www.dropbox.com/s/eztk8zkqz675aew/lists.xlsx

Hello all, I have another tough question that I'm hoping the ninjas can help me crack. I have a list of States and a list of Cities. My client doesn't want to use a drop-down box (says there are too many options, making drop-down box unappealing), thus cancelling out data validation...

Jeff, Very impressive! I'll work to adapt your code to my workbook. I like how it resets the list to "Choose..." when it clears instead of a blank cell. Thank you!

SirJB7, thank you for the quick response. That is exactly what I want to do, however I want to extend it to a third dependent validation. The logic is right, I just don't know how to extend it. Here is a sample workbook that shows what I'm talking about. Thank you for your help!

Hey everyone, I'm currently learning to do VBA (still in the very beginner stage) and I am trying to to write some code regarding three dependent data validation lists. Let's call them "Country", "State", and "City". I want the "City" list to reset when I change the "State" list. Similarly...

Narayank, your solution definitely worked, but I think Smallman's solution suits my problem better. I need to use it with multiple (6+) criteria in the future and Smallman's solution is effective and simple. I never knew a wildcard would return all results! Thanks so much for your help everyone!

Crap I forgot a major component of my question. It is important that I enable my end-user to sum based on 'All' of any one of the criteria. For example, how many 'Dogs' and 'Cats' in 2012 were 'Adopted'. Also, how many 'Dogs' and 'Cats' were adopted in both '2012' and '2013'. I'm sorry I...

Sorry to revisit this old post, but I thought that if I provided a working example (as suggested by Luke) that it would be easier to get some help. I have exhausted searching all over the web and still can't figure this out. Here is the link to the file with instructions explained...

I guess I should mention that there isn't an "All" value in my data, only the months, priority, etc. I have considered including an "All" for each possible combination but considering I have 8,000 rows the file would become enormous. Is there a way to tell Excel that if I select "All" to...

Hello all, I am working on making the calculations section of my dashboard but have run into a problem. I am showing the number of cases completed and the average turnaround time based on three separate criteria that I want to display: Month, Employee, Priority level. I want to be able to...

Managed to figure it out!

I should note that I have also unsuccessfully tried adapting the following VBA code (taken from the article "Interactive Sales Chart using MS Excel") Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(ActiveCell, [plstYears]) Is Nothing Then...

Hello, I have been following along with Chandoo's articles on interactive dashboards. I have used his VBA code from the article "Show Details On-demand in Excel" successfully to identify if a row within a range has been clicked, and if it has to show a value. I am working on a dashboard...

I am working on making a dashboard and am trying to put some cost data into a bar graph. The problem is that when I create the graph it doesn't retain the original order of the data. For some reason it plots the very last data point as the first in the graph. I have searched this site (and...

That worked brilliantly! You truly are an excel ninja! Thanks for your help!

I am trying to determine if a word appears in two separate columns in the same row. The difficulty is that I have to search for the word in both columns. I have had success using {=sum(if(isnumber(find(WORD,array),1,0))} to find out how many times the word occurs in each column. However, I...