Multiple List Values In One Cell

I have a validation on one of my columns for Users to select values from a
list in a different worksheet. This works fine, but now the Users need to
select multiple values in the one cell. How do you do that? A simple
example.
Pet Type
Dog Retriever, Beagle

Good mornngs,

I've searched for a topic to cover this but could not find one so....

Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example)


I've attached an example of what I would like to do -

In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"

Thanks in advance !

dan

I want to be able to use a selection from a drop down list to determine the values for another drop down list:



If I have the above data I want to select "Yellow" from the drop down list in B8 and then have the list for cell C8 be the values in C2:C5. Or if I select "Red" in B8, the options in the drop down for C8 would be the values in D2:D5. I need to do this for multiple rows using the same data table so that I could get to the data above by users selecting all the data from drop down menus.

I'm open to any complicated solution using macros, VB controls, names, or any combinations in Excel. I'm using Excel 2003 and Windows XP.

Hi I would like to create a diagram that should be able to change its content from a dropdown list. The dropdown should contain Days, Weeks, Month, and Quarters. My problem is that the number of entities on the X-axel is different from what I select in the drop dropdown list. Days have 31 different values on the X-axel, weeks have 13 values, Months have 12 values while quarters has only 4 values.

I would like to make the graph understand that if I select days from the dropdown list it should make room for all 31 different values, if I however select quarters the graph should adapt so that the piles are wider and there is only room for 4 piles and so on.

At the moment I have defined the graph to always look at row 2-32 regardless of what the dropdown states and hence the graph only looks good when I select days.

I may not use pivot tables to solve the problem

Anyone who know the solution for this or could give me a hint on how to continue?

Br
Martin

I have an issue that I need some help with. I have a buttload of data (gets recorded multiple times per week) that must be entered manually into excel, this can be time consuming as you have to insert a row for every item that has to be entered. There are approximately 50 individual tables in the one single worksheet.

My question is this, is there a way to have a sort of programmed button that could be pressed that would insert all of the rows at once? Or perhaps a new line could be generated for each table with the only missing data being the values that would have to input manually?

To make it more clear I have attached a sample table. In the sample table, what I would want to do is insert a row at row 47 and at row 93. I want to do these at the same time easily. Keeping in mind that there are 40 some other tables arranged in series like that in one single spreadsheet. I cannot simply hit ctrl and select the two rows and then insert both rows, this would be equally as time consuming to do for all of the rows that would have to be added. Also, in the attached table, most of the values are either calculated values or are hard set numbers. The manually inputted values occur in columns B, E, and F. Everything else is copied down from the previous line.

If anyone has any ideas I will be all ears. Just ask if any clarification is needed as well.