drop down lists

I've got almost one hundred cells with existing drop down lists. I need to cut each cell and move it to another sheet without having to redefine the link to the list data. How can I do that?

Okay, so after reading some of these questions I feel really excel stupid, but I won't get any smarter if I don't ask so... I'm trying to create a formula where excel will add numbers in one column only if the adjacent column's drop down list is on a certain value and then subtract that total...

I have a list of 6 people who play games against each other. At the end of all the games i need to be able to provide a drop down menu if 2 or more people have the same points, goals for, goals against. Can text cells be automatically entered into a drop down menu on a separate part of the...

Ok so basically what I'm trying to accomplish here has to do with an invoicing template I am setting up. I know how to do data validation, so I've set up a list of descriptions for the different things we charge for. HOWEVER I also would like to link another list I created, which are the...

I've been trying to find a way to use the MID and LEN functions in VB. I have an Excel 2003 spreadsheet that uses multiple dropdown selections placed in one cell. What I would like to do is every time the user accidentally selects something that has already been put in the cell it returns...

Excel 2003: I created a form for all my customers, which include a drop-down list (created drop-down list by using validation). I wanted to create an excel document for each individual customer by copying and pasting the 2 sheets into a new book for each customer. When I do that, the drop down...

Hello! I am trying to create a model that has a mixture of conditional formatting and data validation formulas within it, but have run into a problem in one area. Essentially, cell E10 is a Validation which pulls a drop down list of names. One of the options in this list is "Other". I want to...

I am wanting to design a "Front End" for a project I am currently working on. This "Front End" is to direct the user to particular tabs, files etc (probably using hyperlinks). I would like to design this page to be similar to using Microsoft Windows, for example, you would click on "Start", a...

Hello everyone... I am in much need of help if anyone knows how I can make this work... Here is my situation: I have a drop-down list of 20 values, depending upon which value is chosen a different formula will need to be performed. Ex: Drop down list is Dog,Cat,Mouse,Bird,...,Horse...