drop down boxes

Hey all - I would like to create a macro that automatically creates an email for a group of people based on a cell value that's selected from a drop-down menu in a range of cells. There would only be 2 or 3 status options from the drop-down menu, but a specific group of people would be emailed...

I have been looking around and can't seem to find exactly what I'm trying to do. I know I need a VBA script to accomplish my ask. Cell B4 contains a drop down menu Cell B5 is dependent on B4 If B4 = blank then B5 = blank If B4 = "Special/Hard Ticket Event" then B5 = "N/A" if B4 is anything...

Hi All, I have set a simple Yes No data validationd drop down on my worksheet. However whenever I go to the cells with it in it I dont get the option to slect yes or no, the little dropdown arrow to the right appears for a split second but then disspears again. However if I hold the left mouse...

My spreadsheet was created in Excel 2007. There are data validations in a few places, all referring to named ranges on another sheet in the same workbook. The drop-down arrows are missing only for one user, who has Excel 2010. Other users have 2007, 2010, or 2013. The dropdowns were working...

Thanks for taking the time to try and figure this one out! At my work we keep a log of companies that do work for us (particularly create drawings/schematics). We take their name and assign them a number. We call this an F#, which stands for Foreign Number (eg. F-125100-001 thru -999). What...

Hello, everybody! I would like to know if there's a way to unhide cells depending on the choices from drop down lists (well, I know there is). Let me explain it better. Lets us suppose I chose one answer from my first drop down list (the only one on screen yet). Then I want to unhide a range...

Hi wonder if anyone can help me, I am doing a datasheet where I am looking for information from a main data sheet to report onto a front page sheet. Tab 1 is my main sheet where the info will be displayed 1st drop down box selects the tab to gather info from 2nd drop down box selects the area...

I am learning VBA and trying to piece together what I know to automate a spreadsheet. I have a macro that pulls from two source sheets to develop a matrix on a Master spreadsheet. The macro runs based on selections from a drop down list. The macro is an index/match function that pulls the...

I am having trouble with a macro button, that links to two drop-down boxes. My main sheet (YYD), has two drop-down boxes that reference my other sheet (Data). The first drop-down in YYD!F12 selects a row and the second drop-down in YYD!F17 selects the column on my 'Data' Sheet. I just need a...

Dear all, For my job I've to create a new user-friendly template for a lot people who no only the basic of Excel. How is it possible to hide columns or rows with a drop down list? I've a drop down list linked to cell A3. So select the first option in the list, then A3 will be 1, select the...

I have two drops downs; one in A1 (item) and one in B1 (lbs). Lets say I have a list of items A thru E in cells A11:A15 and adjacent to them are the actual weight values of lets say 1 thru 5 lbs in cells B11:B15. Can I combine the information into one drop down that will display in two adjacent...

I am using Excel 2010. I have already created a drop-down box with selections of T-shirt sizes ranging from YXS to XXXL. Original drop-down cell in my form is B23. Named range for this drop-down is TSHIRTS. In my order form, T-shirts are $10 for sizes YXS to AL. However, if someone selects XL...

Hope this makes sense. :confused: Trying to get a problem solved to have a % discount & 'flat' $ discount apply to cell(s) referenced. Product A, B & C are available in 3 different materials. Objective is to allow each material's Max Discount column to apply discount(s) referenced in cell J3 &...

I run a sporting club of about 80 people of whom 40 may be in attendance on any one night. I would like to have a form that displays every members name and a tickbox ( or something similar) next to it, so I can simply tick off the members as they come in ( or they can tick their own name)...

Hi I am trying to get excel to pick a cell from a hiden matrix and showing it on my worksheet. I want to pick the cell using 2 drop down boxes as bellow - 1 drop down picks option on X axis and the second picks using the Y axis and then the coresponding cell in the matrix is displayedMatrix...

Hello, I have a spreadsheet with the same dropdown list in each cell of one column. I would like each drop down list to behave in the following manner: When a user selects the appropriate name from the drop down list the name turns into a "blue colored" active hyperlink to an...

I have created a large number of work instructions using Word templates and I would like to make it easy for our engineers to figure out which template to use for each product. I have created an Excel spreadsheet with drop down boxes that allows them to fill out certain information about the...

Hello everybody, I am facing the following issues while working with Excel ADD_INs 1) i have designed an automation which makes allows the user to access the full Macro through a Excel ADD_IN 2) i have used a couple of forms in the the ADD_IN, which are saved in the ADD_IN file 3) The...

Is there an easy way to grey-out (or deactivate) a load of cells based on another drop-down validation list? i.e. If I select "Microsoft Office" from a drop-down, it will then grey out the next few rows cells beneath it.

Dear All, This is my first post, and I have read as many existing threads as I can find that might help, but not being particularly Excel savvy, I need some help, please??? I have an Excel workbook (Excel:Mac 2008) with 10 tabs, but only two are important at this stage. The first one is a...