drop box

Morning all (well, it is morning here). So I'm using O365 and I'm wondering if there is any way to have excel clear a cell (lets say D16) when you make ANY selection from a drop down box located in another cell? And continuing on from that, as well as clearing a cell so that it contains...

Hello, I wanted to see if it is possible to create either a button or a drop down that can take me to a section on an excel sheet. I have 10 sections that are the same but can take different values in the section The title "Section 1" is on C12 then the next section is c78 and so on meaning...

This is honestly causeing me a headache! I know just enough to maybe toy with a solution but not enough to fix it. So here's the setup: I have 2 columns that are going to fill up via userform entry which log the date a call was placed and the time and duration of the call (in the same column...

Dear All, I've prepared a program for timesheet. Each user will have his own file but I want some information (as the client list and data) to be shared among all users. What I mean is that if one user creates or amends a client, the same will be updated for all the other users. My first idea...

Greetings, Is it possible to create a Drop box that allows you to select a named list and will then insert the data/create the rows below to insert the data? then then if I select Canopy/Seat Removal + Canopy Install it would create rows and columns below filled with the data from that list ...

Hey, I've been having issues trying to set this up so was hoping someone could let me know how badly I'm messing up. 　 I have on sheet one, B15, a drop box that shows from: - "Single" - "Multi x2" - "Multi x3" etc until x10 　 and on another sheet, information that fills in the C column if x2 is...

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...

Is there any way I can do the following with a drop down list? If not please help me find a way around this! To start off I have a tab with different scenarios - let's say 3 - with an on/off filter for each. So Under each scenario I have a unique drop down list with options "on" and "off" If...

Hi, I'm trying to use VBA to log me into a secure webpage, then navigate to a webpage where I need to select a value from a drop down box before searching the database. I cannot get the last part where it selects the value in the drop down box to work, I have used the below code. The...

Dear All, I am using VBA form with combobox list to select and display slides which are containing that particular list item. For example, one of the list item in combox is "pump". If user selects "pump" from the drop down list and execute the macro, then all the slides with word "pump" are...

I have a workbook that has a running master list of job candidates. In the master list there are columns such as candidate, recruiter, location, and other general information. One of the columns contains status information such as "offer extended", "offer accepted", "reneged", "declined", etc...

Hi all, Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any...

I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list <tbody> State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 </tbody> Both tables would look similar to the following: Table 1...

I am clueless as to even attempting this type of problem, but I am trying to figure out a way to automatically have excel to pick the appropriate group based on 1 or 2 options chosen. I work for a drug testing company and when the analysts are typing in patient data and choosing the different...

Hello all, I'm new to the site, but have had many solutions in the past come from here. I am currently working on a tool for my workplace where I use conditional formatting. My first challenge was to have row colors change according to todays date, but managed that. My second challenge was to...

so a bit of background as to what im trying to acheive here: I want a peice of code that runs through all cells & finds every cell with a drop down in. Now the below seems to work but on occassions it doesnt show some cells that have validation(drop down) in them...

Hello, I am currently creating a form that will allow the user to select a portfolio, and then select an item in that portfolio using drop down menus. I have the Sheet being accessed set up in the following manor: <tbody> A B C D E F G 1 Portfolio List Portfolio 1 Portfolio 2 Portfolio 3...

I've been trying to solve with a 2 column drop down. What I am hoping to do is use two columns to aid the user in selecting the correct entry. So the first column will be a number and the second column would contain what the number means If: Col1 | Col2 001 | Horse 002 | Cow 003 | Dog Both...

Hello all, I am trying to set up a event sheet using drop down boxes to track points and events for each player. In the event tab: I have A3:A25 with different events I have three other sheets with players names on it (A3:A30) labeled Group 1,2,& 3. Each event uses two players and I would like...

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> Hi All, Im stuck!! Im trying to create a form for which column E is issues and column F is sub catergories of those issues. So the user isnt faced with hundreds of sub cats' each time, Im...