drop

I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent

Hi, I'm looking for some help with drop down lists....or any other suggesstions are welcome! So in a table, a cell will be populated with a number value and i need the input of another cell to be restricted based on that value. The restriction will be above or below 10,000. I was thinking...

Hello I am using the below formula to source data a from a pivot...

=OFFSET($D$2,0,0,COUNTA($D$2:$D$51)-COUNTIF(D2:D51,""),1 this is the formula that creates a dynamic list for a drop down using data from column D. Data in column D is not sorted in alphabetical order. Without having to sort the data in column D, can the list for the drop down using that formula...

Hi, I cant seem to resolve this: I have made some tables i wish to use in two drop down list with the one list dependent of the choice of the other(indirect formula) The lists is made by using the offset and antalla fomula to avoid emtpy cells in lists. My problem is that when i want to make...

I'm looking for a formula that will provide one single value based on several drop down lists selection. For example : Department (drop down list) : Medical | Marketing | Customer Service Country ( drop down list) : Japan | US | Brazil Expenses (drop down list) : Consulting Fees | Adboard |...

I'm brand new, and struggling. I want to create a drop down menu for a user building a calendar. For example, when the user selects "Weekend" from the drop down menu, the cells within the calendar day are all changed to gray. When they select "Week Day" then it allows the user to make inputs...

Hi there, I know very little about VBA, only starting using it this week by copying from Google, so my understanding of it is very small. I've been searching the net for a solution to my problem, however given my lack of understanding of VBA, have not been able to decipher solutions on Google...

hi, reposting and rewording my question to reflect the time zone I am in. I spent about 23 hours trying to figure this out with a sleepless night but to no avail. I have a UserForm and one combobox on it, I need to add only some of the worksheets to the drop down list and be able to switch...

Hello forum, can someone please help with this problem? Objective: To be able to have specific worksheets in the combobox drop down and navigate to desired worksheet by selecting it. Problem: The script I found online links all of my worksheets to the combobox. I cannot figure out how to...

Is it possible for me to use a Vlookup in a cell in combination with a drop down list. The purpose would be to allow changing the Vlookup answer by selecting from the list. If it is possible to do so, please provide me with instructions. I already know how to create vlookup formulas and drop...

Hi Are there anyone who can help? If I insert a row e.g. between rows 10 and 11 and in the new row I select SUB or RSD from the Drop Down List in column D, the values ​​in the row above the new row, must be copied down, except values ​​in columns H and I. In the new row, these cells must be...

Dear sirs, Drop down list of names , each name reflecting a number. So that when selecting a name it shows its number. For example, in calculating compound interest, the drop down list of names: Annually, Bi annually, Quarterly, Monthly, Weekly , Daily are reflected in the cell by the numbers 1...

Hello, My title isn't the best description, but this is what I'm look for and a link of the data. I am looking to have a Macro create a drop down menu (or some other way to make the selection) on worksheet "Agency" with 7 unchanging options. Location 1, location 2, location 3, location 4...

Hello, I am sure this is a quick fix but for the life me I can't work it out! I am creating a planner with all months going along Row 1. I want to create a drop down so when I select e.g. March it will take me to the month March on my spreadsheet. It is going to be a rather long spreadsheet...

I have 4-6 marcos that i want to be able to choose from in a drop down list.

Hi all, So I have an Excel Worksheet with a data validation drop down. I am trying to have data pasted based on said drop down. The data validation drop down is constantly changing. Based on the table provided, I need Sheet 2 to populate based on a data validation drop down provided in cell...

Afternoon All This question is in reference to a calendar that keeps track of the 7 employees attendance. In my sheet, Cell AI20 is user entry of the first date. Cell AI21 is the user entry of the second date. Once the user enters the second date, the selected (dates) cells are highlighted...

Hi, I have not used VBA in months and my first task back is trying to create a menu page which will have a data validation drop down with multiple selections on there which I want to link too certain sheets. So when selecting "test" from the drop down list then it will take me to the "test"...

Hi, I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is. Here is the info for you. Worksheet is called TEST Drop down list is in column B Cells awaiting data are in column C, D, E Table...