drop down

Hi all, First post here. I have a spreadsheet which is trying to do the following: User makes a location selection from drop down list User hits macro button on the "Test Recording" sheet Button should start by looking at the location selection in the drop down list, and then pulling data...

I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable. I have created a pdf form which is pretty much empty apart from simple things like an email address, logo. I want a different designated person to open that form and...

Hey everyone, how are you all doing? This is my first time here, so please be gentle. No, but seriously, I need help. I want to know if it's possible to create a drop-down list that provides an option for someone to click and begin to type a custom response in the space. Thanks guys!

Hi, I'm using VBA as a drop down so that when I click on the selection it hides all columns except for the ones I need to see for that criteria. My problem is that once I have selected one of the options e.g Newcastle, to see the next option e.g. Carlisle, I have to go back to Select College...

Hi All, I have a data analysis sheet that Im currently working on. I have a drop down list with different entries and I want my code to a copy specific cells (C102:G105) and depending on the drop down menu selection change the paste location of cell in different sheet. I have some of the code...

Hi! I am having a difficult time figuring if I need a VBA for this as I have a source or list with all the items and each cell, I want to select some of the items into a drop down list is that possible? Thank you.

Hi, Sorry in advance if this doesn't make sense! I am hoping someone can assist, I am currently building a Microsoft Access Database for my workplace to keep track of employees and their movements (e.g. Team Changes). I am trying to create an Employee Details Form like in the Student \ Time...

Hello! I'm extremely new to all of this and I am trying to create a drop down menu that will allow me to make multiple selections plus show any results that contain the selected option in any way. D12Order3Urine culture4Urine culture5Urine culture6Throat Culture7Throat Culture8HIV screen, RPR...

Hi there, I have a sheet named Workers with 2 columns. Each column has around 1000 rows. Under the column Shift (B clomun) there are only 3 options: mornig, evening, afternoon. Under the column Name (A column) are names of workers (example below). Name Shift John morning Paul evening...

Hi all, I am trying to have my spreadsheet show costs for running a stadium based on two inputs - Crowd Size and Zones Active. On Sheet One I have two drop down lists - Crowd Size and Zones Active. I also have a Total Cost cell where I require the output. On Sheet Two I have my data set -...

Good day, Regular excel I am needing assistance with the following issues. I have three sheets with data in them, the first one has a list of golf courses, the second has the courses (the name, par, slope, rating). On the third sheet is where I would like to enter the data as I played. Col A the...

I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can. I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the...

I have a problem, want to mirror a drop down list on 2 sheets so that when one or other is changed they both change to that same value I have created the first drop down list using DATA VALIDATION from a table on another sheet. I have then gone on to my second sheet where I want the mirrored...

Hi all, I want to create a sheet where there will be a drop down list on first column and a second connected to first one on the next column. Once I select a value on the first one, I want the next column to bring up the relevant drop down list from predetermined values ( essentially the first...

I have drop down I am trying to count and limit the number of times certain values can be selected. The worksheet is setup like this: Name Role Alex Clerk Jim Admin Stacey Developer Mike Analyst Chris Pool The Position column has...

Hey Folks, Seen a few solutions on here but still stuck on this. .I'm trying to get a solution to set a drop down field that isn't named I'm trying to get it to select "Moving" or "Storage" depending on the customer type but I'm not having any luck Any ideas or help would be greatly appreciated

I'm creating a NFL bracket and I just got all of my drop downs put in and I want to make it so that each team appears with a particular font after it's been selected and put into the bracket. How would I go about doing this? Second question, how would I make it so that each option in my drop...

Hello, I've got an excel workbook. There's a drop-down menu (validated) on the main worksheet I'd like to print to PDF. It populates data based on the drop-down option and the data is pulled from other worksheets. I'd like to 1) select from the drop down menu, 2) print the main spreadsheet to...

I've got three tables TableA: <tbody> List of Tables Other Info TableB Info1 TableC Info2 </tbody> TableB: <tbody> Column A Column B stuff morestuff otherstuff extrastuff </tbody> TableC: <tbody> Column A Column B onestuff redstuff twostuffs bluestuff </tbody> I ultimately...

Hi, all! I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar. I've figured out how to...