drop down filter

So...I currently have a spreadsheet that acts like a call log (Sheet1)(Call Log). In one of the cells I have a drop down menu that allows for a "yes" or "no" answer. I'd like to create a code that when the answer is "yes" a pop box appears with another drop down menu with 3 choices (let's say A...

Hello everyone! I am in the process of making a dropdown-based table to fetch data. I have gone through the motions to create the dropdown via data validation, and that works fine, however I am in the process of trying to get the data I need and I will get N/A in the cell. The table I am...

Hi all. Picture this if you can, in sheet 1, cell A5 to C6 has a data validation drop down list containing MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY. First of all I want copy whichever day I select in to a set cell on sheet 2, for some reason when I click = cell A5 i get the #VALUE ! error...

Hello MrExcel community! I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff...

I am setting up a risk assessment workbook that will pull "Unacceptable" risk levels for a couple hundred machines, each machine being on a separate sheet. I would like to create a separate sheet with a drop down that could search these machine sheets and pull the entire row that has an...

Hello - I am creating a spreadsheet with multiple drop down lists. I would like to make it so that when a selection is made in one drop down. That particular selection only allows you to chose certain selections in the next drop down list. Does anyone know how this is possible I already have my...

First time posting... What I'm trying to do: I have a drop down box with 4 airplane tail numbers listed (Cell A). The cell next to it also has a drop down box with the prices (Cell B). (Cell C) I manually input the variable. (Cell E ) gives me my total. Cell A (Dropdown) N23241...

hope so one can help me out. I know how to create a drop down list, and I know how to do it so that as a person types the list will search and find what they are looking for.. But my problem is it seems it doesn't work with a large group of Data, when to me that is when it is most useful. I...

Is it possible to create a dependent drop list from one source of data? How do I limit selections choice by date constraints? In addition, it filters out the date selection from the first choice and the user can not pick a date going backwards? Creating a market model for senior execs and BOD...

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'm having issues: I have dropdownboxeslinking different sheets within the same workbook and they are dependent on each other. Example: When you select Option A in F4 (dropdown box), subsequently the adjacent dropdown box, F5, should list options under the name Red (RedA, RedB, RedC) as well...