Drop Down Box In Cells
Jun 16, 2009
I am trying to create a drop-down box in cells D21 and D22 which are dependent on each other. From my understanding this cannot be done in Data Validation. For example cell D21 is Route Number and D22 is Route name. If someone knows the Route Name they would select it from the drop-down, then cell D21 would fill in the Route Number. Similarly if they know the Route Number the Route Name would fill in.
I am able to have one dependent on the other using Data Validation and VLOOKUP, however not dependent on each other.
View 6 Replies
ADVERTISEMENT
Apr 5, 2009
I have a form with 2 columns. in the 1st, we have the product and in the 2nd, we have the price.
I have my drop down list for column1 but I want column 2 to show the correct price when column 1 has a product.
View 4 Replies
View Related
Oct 20, 2009
I have a drop down box that shows progress of a project. The options in the drop down box are 0%, 25%,50%,75% and "Completed" - I am wanting to make it so when i click the desired option in the drop down (say 25%) it makes 25% of the cell show green (or completed)...all the way to when I click "Completed" then it will make the cell 100% green. I am trying to show a percentage of something getting done by way of color.
View 6 Replies
View Related
Aug 11, 2006
I need to place a dropdown box with three options in all cells in lets say column C.
View 2 Replies
View Related
Jun 20, 2014
Drag & Drop Example.xlsx
In the example attachment on the weekly tab, you will see I have daily totals and a sum for weekly. On the summary tab I have the columns going down with a link to the weekly totals.
I have over 5 years of data in this format and don't want to link each cell in one sheet to another. If I drag and drop, obviously the weekly doesn't come down correctly.
Is there another way as I don't want to have to do this for over 250 weekly totals (and counting) manually.
View 3 Replies
View Related
Jan 20, 2010
when I select a value from my drop down list how can I fill in say.. cell A50 with a number automatically?
Pretty much on a drop down selection I want to fill in another cell.
View 11 Replies
View Related
Oct 8, 2009
Say you have two columns, A & B. Each cell in column A consists of an identical drop-down menu of four possible choices. Each cell in B is a random number. I want to sum the cells in B according to what the user selects from the drop down in column A. If A1=A2="BILL", I want the sheet to add B1 and B2. IF A1=A3="BILL", and A2=A4=TOM, I want the sheet to sum B1 and B3, then sum A2 and A4. So, conceptually, I guess column A acts as a group identifier, and I want to sum B by group.
View 2 Replies
View Related
Apr 29, 2006
I have a spreadsheet where I often have to exchange pairs of cells. I currently do this by dragging Cell A to a blank portion of the sheet, dragging Cell B to Cell A's former location, then dragging Cell A to Cell B's former location. I was just thinking that I might be able to use VBA to allow me to drag Cell A to Cell B and have them "trade places".
I don't even know what events are involved in the dragging process so I don't know where to start.
View 7 Replies
View Related
Jun 30, 2014
I have a numerical value in cell B2 , and a drop list that contains unit names.
I am looking for VBA to see which unit is selected in the drop list, and then add B2's value to that particular unit's total.
See attached workbook : oz_addition_example.xlsx
View 4 Replies
View Related
Jul 7, 2009
I have a document I was directed to fill in. I was instructed to only use a certain number of characters and then drop into another cell below it for paragraphs of text. I have now been told they made a mistake, need me to copy all the related cells for a specific paragraph and drop them into a single cell.
Can I copy the text in multiple cells, and then drop the cell formating of those copied cells and drop the content into one single cell. Either word wrapping the content or soft returns for what looks like paragraphs again?
View 4 Replies
View Related
Sep 7, 2009
I have a rather simple problem (tough for me!). I am setting up a food log. I would like to have one column with common food items that I have in a drop down list. The list would be about 20+ things. The other columns would have relevant nutritional info such as calories, fat, carbs, etc.
The problem is how do I make the values in the other columns change depending on which food item I pick from the drop down list?
For example, if I choose bread from the list, how would I get the columns for carbs and calories to change accordingly.
The IF function would be too hard because I couldn't nest 20+ IF functions in the formula for each cell. Also, the drop down list would change as my diet changes, possibly reaching 50+ things.
Also, I would like to manually enter a serving size that would alter the nutritional values in each column (for example 0.5*Calories or Carbs).
It seems so simple in my head, but I can't figure out how to get it to work.
View 6 Replies
View Related
Jan 21, 2010
I've used this site for help many times, but this was the first time I couldn't find the answer to my question through searching. I've looked all over this site & elsewhere, tried 2 dozen different solutions, and nothing seems to work.
I've used a budgeting spreadsheet for years, which lets me plan bills weekly according to paychecks. For each month, going down the "Expenses" column, there lists are seperated by when they'll occur. So there may be three blank cells, then electric bill, mortgage, blank, blank, cable bill, blank, cell phone, blank, gasoline.
On the checkbook worksheet, I want to enter a drop down box for the Expenses. The problem is, every solution I've found for doing this is aimed at eliminating blank spaces at the end of the list. This by necessity has to have blank spaces throughout the list, but I would like them to disappear in the drop down menu.
View 3 Replies
View Related
Oct 13, 2009
I would like to drop down the cells in B4 and D4 so that if throws up a result in D6 which looks at Sheet 2 and throws back that score? So it will look for Neil in Column A and October in Row 1 and throw back that figure.
View 3 Replies
View Related
Nov 27, 2009
I need to add drop boxes (from data already listed on another worksheet) to every cell in a single column. Drag down, easy! My problem is that I already have the required list (names in this case) pasted into the column from another sheet.
Is this possible?
View 2 Replies
View Related
Mar 9, 2007
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.
View 6 Replies
View Related
Oct 15, 2007
I am busy with a project using VBA to populate a spreadsheet based upon the data entered into a particular cell. The problem that I am experiencing is that I populate the initial cell via a combo-box which I cannot exit unless I click elsewhere with my mouse. The code that I am using to populate the other cells is as follows
Private Sub Worksheet_Change(ByVal target As Range)
Application. ScreenUpdating = False
On Error Goto dump
Dim r As Range, MyRowNum As Long, ws1 As Worksheet, ws2 As Worksheet, strPriCode As Variant, _
strNAPPIE As Long, strSInCost As Currency, strSInDesc As String
Set ws1 = Worksheets("SINVOICE")
Set ws2 = Worksheets("STOCKIMP")
Set r = ws1.Range("B11:B35")
If Intersect(target, r) Is Nothing Then Exit Sub
If target > 0 Then....................
View 2 Replies
View Related
Apr 29, 2008
Now he has another task that I am not having any success with. He has asked if we can make an Excel spreadsheet that allows us to access a list of customer units from a drop down menu which is in another workbook, and once you choose that particular unit, another drop down menu will allow only those customers who are assigned to that unit to be selected from that sub-menu. I hope that makes sense.
Say customer A1 (we will call him Delta Co, 2-1 Aviation) is selected from this first drop down menu (which I haven't figured out how to make yet either). Then this selection would access another worksheet in that other workbook with a new drop down menu with only the four customers in that unit. As an example we will use the names SSG Wilson, SGT Jackson, SFC Jones, and SGT Phillips.
So when the Supply Tech here opens the spreadsheet, the first drop down menu, he will select Delta Co, 2-1 Aviation. Then the next menu will only show four names, and he will select SFC Jones.
Once we get this going, I may be able to figure out the other things the commander wants, if not I will be back.
View 9 Replies
View Related
Mar 2, 2014
I am using the cell validation command to create a drop down list on sheet1. Drop down is created from sheet 3 column A
I would like sheet 4 to be filled by information from both sheets. first line would have item chosen from drop down and the next line would be sheet 3 column B.
It is for a catering company. Sheet 1 (menu) is the creation sheet. I would like to use a drop down list to choose from a long list of appetizers. Those of which are on sheet 3 (app list) and held in column A (1-42). As that occurs, I would like sheet 4 (prep list) to generate a list of operations. A1 (prep list) would reference the item chosen and A2 would be the list of operations (sheet 3(app list) column B)
View 7 Replies
View Related
Jul 5, 2014
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.
=INDEX(crew, MATCH(C10, Personel!D2:F4, 0), COLUMN())
View 2 Replies
View Related
Feb 11, 2009
I am trying to figure out how to reference a number of cells from accessing one drop down menu. I have a list of products with pricing and logistics. I would like to have the drop down menu in another sheet that will access a specific product and the pricing that goes with it. I know how to do it if i wanted 100 seperate sheets, but I would really love an all-inclusive page that refreshes with the drop down menu. I have a copy of the file if that i hope will be helpful with colour coded cell references.
View 2 Replies
View Related
Feb 17, 2009
If I choose 1 thing from a list I want it to then fill in many cells with info.
For example: I have a color list to choose from, once I make my choice cells near it fill in with 1.5lbs yellow, 2lbs blue, 4lbs red,.....or what ever I have established as the "recipe" for my color choice. When I choose a different color from my list these cells each fill in with different values.
View 9 Replies
View Related
Aug 1, 2009
I am looking to have the Cells that I have applied a Dropdown List to update with the changes that I make to the list itself.
Example:
If I were to validate a list with a range of a1:a3 using "Bob" "Sarah" "Bill" and then apply that list to B:B and randomly select from the three names running the length of B:B, I would want that when I go back to A2 and change "Sarah" to "Linda" that every "Sarah" that I have selected using the drop down will update to say "Linda"
I hope that I am explaining myself clearly and in a simple context.
View 9 Replies
View Related
Jun 8, 2007
I have created a pricing sensitivity for a list of products. In cell C3, users can select a product (i.e. Apple, Elmo, or Bowl) and based on this selection, a range of Prices and Units are then updated and the Revenue for each price point calculated. A few lines beneath this, I have a little summary table that lists all the products. I'd like for users to be able to enter in the optimal price point for each item and then have the Units and Revenue for that selected price point for that specific product automatically update.
For example, if I select Apple from my drop down list my price choices are $5, $10, $15; units are 100, 85, 70; and revenue are $500, $850, and $1,050 respectively. On the summary table, I would like units 85, revenue $850 to update automatically if I select/input a $10 price. This would happen for all the products so at the end I want to be able to calculate a blended revenue mix given my pricing changes.
View 9 Replies
View Related
Apr 25, 2008
I am attempting to populate a row of several cells on a worksheet using a drop-down list, using data from a seperate worksheet in the same workbook. The worksheet containing the data will be hidden (I do not think that matters in this case). Do I place a VLOOKUP function in the first worksheet cells? see attached sample
DropDownSample.xls
As a follow-up question, as time goes by, the data in the source worksheet will be appended with new items (additional rows of data). As each new item is added, will I need to edit the formulas, or is there a way for Excel to dynamically add the new data? This might be stretching my wish list a bit but I thought I'd ask.
View 3 Replies
View Related
May 26, 2014
I have a drop down list that shows phrases for different math functions, like "divide by 2," "divide by 4," divide by 8," etc. When one of these items is selected, I want it to perform that specific calculation on a range of nearby cells.
However, I also want the user to be able to see the original value of the cells if they select "show original value" from the drop down list.
I have attached a workbook as an example. I think macro would probably work best.
oz_list_math.xlsx
View 5 Replies
View Related
Sep 22, 2008
I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.
This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)
I have made drop down lists to select each of the values for the three conditions and want to show the total for them
i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.
i.e. i am away for 6 days i get £15 extra, if i am in Europe i get another £50 and if i work 12 hours i get £30.
I want to be able to calculate this total in each cell for that day.
I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.
View 12 Replies
View Related
Oct 2, 2007
i have a list which is populated with data from another sheet.. if there is no data in the corresponding cell on the other sheet then the cell is blank.. i've tried using:
=OFFSET($Z$2,0,0,MATCH(REPT("z",255),$Z:$Z))
but it doesn't see the blank cells as blank i.e. no data in them as they contain formula's.. (even although there are no values populated) - can anyone offer any help in relation to this???
View 9 Replies
View Related
Nov 22, 2008
what its called when you have drop down menus that correspond with other drop down menus.
View 2 Replies
View Related
Oct 25, 2006
Here is what I'm trying to do:
I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people
On "main" I have 1 drop down box and 1 cell:
the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.
then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.
View 2 Replies
View Related
Dec 5, 2007
Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.
On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.
Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.
View 3 Replies
View Related
