I'll set up the situation first: I have a group of cells (arranged in a esthetic manner) across several rows of columns. For example, column A1 to N1, rows 1 to 5.
I'm hoping to set up a drop-down list in a cell (we'll use A2 as an example), with different options that will determine what text is displayed in different cells in the group when the user selects it.
For example, if I selected option 2, it would display different text in cell B4 than if I choose option 1. Again for option 3, etc.
If this is at all possible, there is an additional question. Can this format also insert drop-down lists, instead of text, in select cells?
I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group.
I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .
I've managed to create a drop-down list with the following possibilities:
Yes No Others
When the option Others is selected, I would like the user to be able to input additional information in a new line with wrap text formt (this new line should be hidden when either Yes or No is selected).
I currently have showing 800 suppliers in a List Box... sadly when having to search for a sepcific supplier this seems to be very fustrating and time comsuming for people in the Company.
I have tried the method of copying all of the Supplier above the list, so it can do an AutoComplete filter, but the data needs to be exact.
What i would really like is if i was to type the letter "V" in the cell, it would be able to provide me with a list of the "V" suppliers in a list.
The list is a crew list and I'd like to be able to select the foreman, but I'd like the crew cells to be populated with the information corresponding to that specific foreman. I've named the data range and created the drop down list but i cant figure out why the crew column wont populate with the crew. I am using a different sheet for my data.
I tried VBA but I am hoping I can use Index and Match.
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
ram ram ram reddy reddy reddy lakshman lakshman lakshman and i want to incert blank after the end of each group and i am expecting like this ram ram ram
reddy reddy reddy
lakshman lakshman lakshman
is it possible to do with simple formulas or i need macro for this? i have huge file with lot of groups like this i can not do this manually by using filters. have look on attched sheet for better understanding.
I am working on a contact information form for given relationships, and I'm trying to figure out the best way to design a button that copies the "form" (not an actual VBA form but a grouping of formated cells for information collection) and inserts it into the document. I would also like a button that deletes unused and empty forms so that we only print forms that are filled in.
I tried recording a macro to do it, but it's messy and creates issues with hidden rows and pagination.
I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example: FAILED - whole row changes red SUCCESSFUL - row has no fill Tested - row changes to orange
I am trying to a input a list of cells in a column depending on what option i select from a drop-down list (or validation list) eg. If in A1 I select "fruit basket" (from a drop down or validation list) I then want this option to input in Column B Items located in another dynamic range eg. Apple, Banana, Orange, Grapes.
I have attached a sample of what I am trying to do to help explain my situation.
I find these forums a great key to learning the intricacies in Excel.
I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15 A drop-down list displays the values 1 through 15. Cell A1 changes to 20 Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.
why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.
I have a sheet below, where I want to sum the value on a set of data on another sheet. The formula will be where the "???????" are. Each row on the other set of data will have a cell that's either 100, 200, or 300.... the row will also have a number that's either 1010, 1020, 1030, 1040, 1050, 1060... And there are many rows of data for each combination, thus why I want it summed up in the "???????" cells.
I need to create a 'sub' list from a drop down list.
I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.
And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.
I have 7 cells containing strings but not numbers on a row.
Now I want to list out all the combinations of drawing out 3 cells out of these 7 cells while the remaining cells that haven't been drawn out could also be listed out one column next to the drawn cells.
For example, I got 7 cells like this.
A B C D E F G (each letter in ONE cell)
And I want to list out all the combinations like this:
ABC DEFG ABD CEFG ABE CDFG ABF CDEG
etc.
For more details, please refer to the attached sample (an .xls file being zipped).
I have a list of items in column A ("Questions"). Let's use 3 for this example.
I have seven respondent GROUPS, represented by a column.At the intersection of each QUESTION and each GROUP, a number appears, indicating the most popular answer to that question expressed as a number from 1-6, or BLANK if no response was the most popular answer.So the data looks like this:
Group1 Group2 Group3 Group4 Group5 Group6 Group7
Q1text 1 5 5 3
[Code] .....
Now... the part that will seem upside down...I want this sheet to allow the user to specify a GROUP and a RESPONSE ID (1-6) to produce a LIST of QUESTIONS that will be used as the contents of a dynamic dropdown.For example, if the user selected GROUP6, RESPONSE4, I'd like the dropdown to contain:
Q1Text Q4Text
If the user selected GROUP1, RESPONSE1, I'd like the dropdown to contain:
Q2Text Q4Text
It is not possible for the RESPONSE selection to be "Blank", though blanks do appear amongst responses.
I can't get solutions to switch dynamically based on the selected GROUP.
So we had a month long, company paid (woohoo!) "weight watchers" challenge. On 1 worksheet ("Stats"), I have the Name of every Employee (A Column), then their Start Weight (B Column), End Weight (C Column), Department (D Column) and finally Location (E Column).
I know how sensative some people can be about their weight, so I locked the page and created another worksheet named "UI", which will display the "Average End Weight" for each department. So Human Resources would be the department in cell A2 on the UI sheet, with City 1 being the Column Header in cell B1. There are 8 cities (offices) and 23 departments.
So, for cell B2, I want to scan through the "Stats" worksheet and locate all of the cells in the department and location columns that read "Human Resources" and "City 1" respectively. Then grab the "End Weight" for every row that meets these 2 criteria, add them up, and divide by the number of "End Weights" that were grabbed.
My solution would be to make a separate column for each department (and then each city, so essentially 8 columns to represent all the cities for each department), use a nested (maybe 4) IF statements to then list only the end weight if that particular row meets the criteria, then at the bottom of each separate column, add all the shown numbers up and divide, then draw the information from THAT number into the "Average" cell on the UI worksheet. But it isn't very dynamic and if i want to use this sheet next year, there will be more employee info to be added and it would be a mess..further more, it would be...what...23 Departments x 8 Cities x 155 employees = ~28,500 added cells.
i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.
so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.
I have a workbook with around 35+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down list in say cell A1 so it would be easier to navigate the sheets. Is this possible with out using VBA code if so how would I go about doing it?
I have a drop down list of shipping Companies. If the name of the company is not in the drop down list how do I allow the user to type in the name then have it save in the drop down list source?
I am trying to figure out how to Concatenate a group of cells if they contain a certain text. Basically I have a list of Architects in column A and the account name in column B... and I want to say Concatenate column A, IF column B=Specific Account (ex: Coca-Cola). The list will be added to frequently so the formula must refer to the entire columns, not just a certain range.
As of right now, only the first architect associated with each account will appear. I have attached a workbook with the example..
I currently have a drop down list in sheet 1 and the list is being refrenced from sheet 2
Lets say the drop down list is for fruits and my current list in sheet 2 has 4 items Apple, Grape, Mango, Peach.
Now this is what I need :-
1 ) lets say a user wants to enter Orange (which is not in the list ) he can still do so by entering it manually into the cell.
2) Once Orange is entered which is not in the LIST in sheet 2 then that new name gets added to the LIST in sheet 2 so that next time that name appears in the drop down list automatically. eg Apple, Grape, Mango, Peach, Orange [ but Items should not get duplicated eg Apple, Grape, Apple, Mango, Peach, Apple
I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?
I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.
im trying to create a spreadsheet for different makes of cars, here is what i want to do.
in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.
