auto fill the rows after selecting a particular option from a drop down list. For Ex., In Drop down list we have Cool drinks and Ice cream as two options. If i select Cool drinks the respective columns should be filled with brands like, Coke, 7 Up etc...
View 3 RepliesI would like to auto-fill cells based on what I select from a drop down list.
For Example:
Drop Down List is located in A1(already created). Let's say it lists items like bathroom,front of building, dinning room etc.
I have created on sheet 2 a list of responsibilities for each item on the drop list. The list has a header for example bathroom and a below it list the responsibilities. I did this for every item on the drop list.
Now, is it possible to select bathroom from the drop down land when selected the list I created in sheet 2 show up in the cell next to bathroom? Also, is it possible to have this happen every time i select a different item from the drop down list?
I've created seven names in my data validation source list on Sheet 3 in the following range of cells, A2-A7. My data drop down validation list is located on Sheet 1, A2 in the same workbook. I would like to trigger a macro based on the name I select in this drop validation drop down list that will fill out an address, telephone number, and email address in the following cells next to my data validation drop down list on Sheet 1: B2, B3, and B4. I want it to be designed so that users will select a name and have that person's corresponding address, telephone number, and email address fill right next to their name on the same sheet.
View 6 Replies View RelatedHow to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.
Attached files for reference :
Dropdown Month.xlsx‎
MONTHLY DATA.xlsx
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.
I am trying to create a sheet for identifying work hazards based on the job assigned. So what I have set up is a drop down list to select the job type. Once this job type is selected I want the pre written hazards to autopopulate in the hazard box. I would also like the required PPE to appear in the PPE box for the job selected.
I have 6 different choices in the drop down list. For each choice I have the hazards and PPE in a separate sheets in the worksheet.
Is there a way to get this information to autopopulate?
I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.
The dropdown box has been put in the form using the data validation function.
If I make a selection using a drop down, can I have it auto populate another cell with information associated only to the made selection? For instance, if I select January from drop down in A1, I want it to auto populate B1 with 100.
View 2 Replies View RelatedI am not sure the correct term for this but the autofill drop-down menu that pops up when typing code does not come up for me.
Example:
Sheets("Form").combobox1.
I usually get a drop-down menu with a list of members of the "ComboBox" class.
Is there a setting for that enables/disables this?
I am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 7 Replies View RelatedI am trying to make a spreadsheet where I use a drop down menu for several of my vendors. When I select the Vendor's name from the drop down menu (for example in A1), I would like A2 to display that vendor's phone number. But when I switch vendor name from drop down list in A1, A2 would need to reflect the new vendor's contact info.
View 5 Replies View RelatedI am trying to create 2 drop-down lists (based on named ranges), where the contents of the second selection change based on the first selection. On one sheet, I have a list of equipment that is quite long, but is broken up by categories. I have named ranges for all the category names, and the equipment in each category. On the other sheet (user side) I made the first drop down the list of categories, and would like the 2nd drop down to be the pieces of equipment that correspond with the chosen category. I have tried using data validation and nesting IF formulas, but it only works for the first 4-5 categories, bc my formula is longer than the Source field allows in Data Validation. Any other way I can make this work? Can I use a macro for this? If so, how to write it as this would be my first macro
View 9 Replies View Relatedhow to create drop down lists which is making a sales forecast template for my small company look pretty jazzy. Of course, now I want more out of it and can't figure it out.
I successfully added a drop down list for a sales person to pick a supplier, let's say their selection populates cell E4. Once selected, the next cell over (F4) gives them another drop down list with the products made by that particular supplier. The next cell over (G4) is in a column titled "Unit Cost", how can I make the Unit Cost cell populate automatically when the product selection is made in F4?
NOTE: My "lists" are on Sheet 1 along with my working spreadsheet. I have a Suppliers List, Products List (for each supplier), and anticipate I will need a Price List for each Product List, right?
Once I finish the spreadsheet can I cut and paste all the data to sheet 2 (I put it 100 rows below my spreadsheet to hide it)?
I want our sales people to be able to select from the list of products we manufacture and have they corresponding information automatically populate. For example, if the salesperson is trying to put a quote together for 500 lbs. of Stainless Steel nails, they can select the correct size and have the list price, cost, margin (etc...) fill in the adjacent cells automatically.
View 5 Replies View RelatedI have some data validation drop down lists in excel, I can tab through all the lists but I have to press alt + down arrow to show the list, Is their a way it can be automatically shown as soon as I focus on the tab.
Check the attachment: Survey.xlsx‎
I am working on Excel document(Microsoft office-2007) with 2 sheets(Sheet1,Sheet2).
In sheet1 i have a dropdown list and the respective data is saved in Sheet2.On selection of dropdown lists in sheet1 ,respective rows should get copied from Sheet2 to Sheet1.
I am having trouble with the macro command. This is a first for me and I am stuck. I just dont know the how to write the Macro for this.
I have a shared worksheet that has many rows of data... but only certain rows are relevant to each specific users. I would like each user to be able to select their name from a drop-down list in order to have all rows that are not important to them be hidden. I can put the name of the user in column 'A' in each row they need to see, but how could I make all rows that do not contain their name in column 'A' hide? In other words, if 'Bill' is selected from a drop-down list, only rows that contain 'Bill' in column 'A' would be seen.
View 9 Replies View RelatedI've made a drop down list and when I select multiple cells and choose from the drop down list, it only fills one. Here's pictures:
So in that first picture, I've selected multiple cells. But when I drop down the menu and click my selection, this happens:
Why is it that all the cells I've selected does not fill with the option that I chose from the drop down. I highly doubt that I have to manually click all the ones I want to fill with what I choose from the drop down list.
I have a budget document that has a selection (Named Range with list items in a drop down) Approved, Rejected, Awaiting Approval or Blank. What I would like to do is set a process that could approve all Awaiting Approval. My thought was to create another choice box at the top that allowed the user to choose approve all awaiting and it would select every matching item that was Awaiting Approval and change it to Approved. At the same time I would like it to set the date and time, this could just copy what I put in an associated field or be real time.
View 9 Replies View RelatedI am new to VB macros, I am trying to figure out how to color a tab Green based on a selection from a drop down list.
View 9 Replies View RelatedI need to make a dropdown list (I know how to do that) and based on that selection, I need some cells below to automatically complete. How can I do that? Is it possible with or without VBA?
View 5 Replies View RelatedI have a worksheet that allows you to choose 1-20... depending on the selection it should unhide specific rows but I keep getting errors...
Code that will allow you to unhide other worksheets in the same book????
is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1
View 9 Replies View Relatedi'm looking for is that I have two lists via Data Validation, and when someone changes their selection in list A, i'd like for list B to auto-delete whatever value it had in it.
Also, on a different topic, i'd like to know how to hide certain sheets in a workbook from public view.
[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.
Edit: using Excel 2007.
I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.
I have a cell in my spreadsheet that I use to control the size of a column. I formatted the cell as a number and added data validation to make sure the number is greater than zero. Then I realized that I need to also allow for the option of auto sizing the column as well. This would require a data validation list type with something like True and False for the choices.
What I want to be able to do is have it both ways. I want a drop down list in that cell with the options Auto Size or Custom. If Auto Size is selected the cell value gets set to that. If Custom is selected I then want to be able to type in a number.
ddl.png
[URL]
Is there a way to setup a cell such that the value is either an item from the drop down list or, entered directly (depending on the list selection)?
I know I can do it with dependent lists but that would require two cells, one for the auto size mode (true/false) and the other for manual width value.
Is it possible to do a drop down list that allow user to select pre-defined selections but everytime when a selection is chosen, the list reduced?
Example,
I have can choose Apple, Orange, Durian and Mango.
The drop down can only select these 4 fruits.
So there are 4 cells in Column A1, A2, A3, A4.
A1 selects Mango and then A2 will only have 3 options to choose. So until the last cell, he can only choose the last fruit left.
A1, A2, A3, A4 are not selecting in descending order thus it could be A3 selecting first, then A2 and then A4.
I'm using excel 2007
I would like to be able to limit a drop down list's contents based on a user's selection in a different drop down. I am using Excel 2003, and I know how to do this in Access, but I can't figure it out in Excel. Basically, I have a list of themes in one drop down. The user picks a theme, and goes to a second drop down which is a list of sub-themes attributable to that one theme and no other theme.
View 1 Replies View RelatedI am currently building a sheet that requires a drop down box that will auto-populate two separate fields. I have tried to the point of being suicidal to make this work but to no avail.
A detailed explanation:
The worksheet containing the drop down list and fields that need to auto-populate.
sheet example.png
The raw data, located on a separate tab in the same workbook. (Note: there are over 1500 rows of data)
sheet example 2.png
The drop down box will be in the "Description" column and will contain a list of services my company provides. Once selected it will auto-populate the "Rate" column and the "Item ID" column. The raw data that the list is pulling from is located on a separate tab.
I can make the list just fine, it's easy enough to just go to the Data Validation feature and point to where you want the list and where you want the data to come from, but getting the list to pull the data from different columns and go into the columns on the work sheet is apparently beyond my knowledge of excel. I figured it would just be a simple formula setup through the VLOOKUP formula wizard but I've tried it at least 20 different ways, all of which fail. I've tried HLOOKUP too but it also failed.
I am looking to auto generate a roster/schedule. I have a spreadsheet with shifts for each weekday that I need to populate every week with names to pick from a drop down list. the drop down list is made using data validation and looks at a dynamic named range to allow me to select only the people who are available to work a certain shift.
Is there a way to do this using vba?