choices

Greetings all, I am looking for a way to do something similar as (Student Choice), and I have tried to manipulate the macro but it's a bit more complex and beyond my brain power lol. We have at a sports school for kids ranging from age 3 through adults and given the popularity would like to...

Hi Guys, Forgive me the thread title, but I had no idea how to call it. I'm having a table, where I have to choose Yes/No. If I choose Yes, I want this choice to be displayed in another table. It can be partially done with a pivot, but I need to press refresh each time I make any changes in my...

Hi, I'm usually an Excel person and not so much an Access person so please forgive my stupid question: I plan to build a database which in various forms rolling up into various tables I want to control selection choices a user can make. Some of these list might be 3 options long, some might be...

We have a program we use for some work, its a exe file that runs in a dos window. It starts with a menu of 5 choices, and I would like to use excel to populate the menu choices, and also other operations. Is this something excel can do, or is there a better way? It would involve opening files...

Hi, I've got a dataset of respondents in the format of: Respondent 1 - Choice 1 - Choice 2 - Choice 3 etc. Respondent 2 - Choice 1 - Choice 2 - Choice 3 etc. [for 100s of respondents] I am trying to allocate choices so that each respondent gets as many of their choices as possible The issue...

I want excel to limit A3:A1003 user to only input numbers 1-1000 for their choices form highest to lowest and if they go out of order to alert next value is the missing number ex: if users input 1,2,3,4,5 and if users accidentally tries to input 7 as next value for excel to prompt message "...

hello. I am working on a userform in which I would like to have 2 criteria options; the 1st being a number (1-100) and the second being a choice from a drop down list. When user enters the number and selects the drop down - I would like 4 different list boxes to generate information. Example...

Hello, I have a spreadsheet where column A represents a person (1-242) and column B represent a choice that person made (1-5). Each person in column A gets to make 12 choices (i.e. there are 12*242=2904 rows). I would like a formula that counts the number of unique choices each person makes...

I have two data validation lists. The second is dependent on the first. So let's go with the old fruit and vegetable tables. First list, my choices are Fruit or Vegetable. The second list is dependent on the first. Let's say if you select Fruit, your choices are Apple, Orange, and Pear in the...

So my spreadsheet has 7 drop down boxes with 10 choices, they all have the same choices which are Meal Choices, the ingredients are listed left to right in a table on a different sheet. This is to generate a complete ingredient list in a table of ingredients (already created) for all 7 drop...

I am working on a spreadsheet and want to call a picture based on an if statement. There are 6 main choices with 8 sub choices. For example: You wouls choose a car model with an X, and then choose a service also with an X. Them you would click a button, "Submit Request". the program would...

Hello guys & Gals, I have excel 2013 and I am trying to do something but cant seem to. In column A I want a leading / before any data I enter in the cell. So for example I want "/time" or "/545" (just examples.) I tried custom format and format tried was ?"/"? and tried 0"/"0 and several...