drop downs

Hey everyone, I'm trying to write a code that hides rows based on cell value, but with a twist. The cell that it is based off of is a drop down. I have it to where you can select multiple options within the cell. I have a list of colors in the drop down and at the end I have a "Special Color"...

Hi Gurus, I have a stomper. I am trying to hide/unhide columns based on three different drop down lists. The below formula works to hide/unhide when individual drop down lists are selected, however does not work together to "filter down" and show only the columns that apply when all three...

I have a spreadsheet with three columns of data. Column 1 and 2 have multiple matches. Column 3 are all unique values. I am trying to make three drop downs that only show unique values in each based on the selection from the previous drop down. However, only tutorials I can find have 2 columns...

Bonjour all, First time poster! Been using this site to help me make some spreadsheets for work. All have been a great help and have been learning new things and tricks every day. Anywho! Thats enough of me....I have a problem I am trying to get around and wondering if you all could help? I...

Is it possible to change the currencies shown as options in this drop down list? I am constantly using two or three currencies and would like to be able to add the other two that aren't USD to that list?

Hi, I've encountered a very frustrating situation after conquering what I thought had been the hard part of my project. I spent a good part of today looking around on Google and this forum in search of a solution without having any success, so I'm hoping someone can give me a hand! What I'm...

What im trying to do is set up a contact sheet in the back of a workbook company, contact name, ph, fax, cell, email and then on our proposal page i want a drop down that allows you to select the company(with no duplicates) and based on that selection it will give you a drop down for the...

I've seen lots of help on how to disallow special characters when using data validation but nothing on how to ALLOW special characters. I have a pretty big spreadsheet that I'm working on that will be pushing the limits of data validation :). I'm really trying my best not to change the names...