drop down lists

Hi Members I am trying to create a spreadsheet for our tennis club, We may have members that play on multiple teams , on our calendar to schedule matches I would like to be able to restrict the drop downs if a player team is selected then any other team that they play on can not be selected...

Hi there, I have the below code, which is working well at hiding and unhiding rows depending on the number of investments selected from the drop down list. In additional to my current code, I was wondering if I could go a step further and hide further rows depending on the outcome of 2x drop...

Good morning I have previously received some great assistance for a problem I had using the Countifs function from Joris, a board regular. I wish to expand on this formula to be able to achieve a new level of functionality for a project I'm working on. I currently have the below data on one...

Hi I kinda know how to do this with single cells but not with named ranges...everything I have googled so far seems to point to dependant or cascading lists but is not what I need....anyways Basically Say I have a drop down list in column A (in each cell) A drop down list in Column B (in each...

Hi there, This is my first time posting and really have little in-depth experience with excel. With that said, I am tasked with creating a spreadsheet for calculating some estimate numbers at my work. So here is my dilemma. I have a cell in A1 that is a drop down list. Based upon what you...

Hi I am trying to create dependant drop down lists but am currently having issues. I understand the concept and can get it working when I hardcode the ranges as a named range, however when I use the offset function in the name range I cant get the dependant drop down list to work. For example...

Good Morning, I am trying to create a sheet whereby a table returns only those values that are selected from either one of two drop down lists. The first drop down list has categories, for example: Onboarding, Facility Management, Admin Tools. The second drop down list has specific areas of...

Hello! I am currently running into issues while using the If Formula with multiple drop down lists. Currently, there is a mandatory drop down on sheet 1 in A8 with five options. There is also a mandatory drop down list on sheet 1 in B8 that is reliant on A8 selection. There is then three more...

Hi, For some reason, my index match formula isn't working. I want to automatically populate two other boxes based on a value entered in another box that is selected from a drop down list. I am using an index match for each box separately, but it returns with #N/A. =INDEX(array of desired...

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

I've been working on a spreadsheet for custom quoting jobs for my business. It has multiple dropdown lists feeding from different worksheets where one of the lists is dependent on the other. The first drop down is straightforward and is a choice of every material we have available. The second...

I have several columns with drop down lists. Is it possible to format a row to highlight the cells with the drop down lists to notify the user to ensure those cells are filled out. For example, if someone types into a row, I want certain fields (the ones with drop down lists) to automatically...

Hello Everyone, I have a validation drop menu (data / validation / settings / list) that I want to disable when one date is greater than another date. So for example today is 5th November but I want the drop menu to disable when the date is 6th November. Cell C1 contains a start date (can be any...

Hi Guys, I wanted to know if there is any way that I can get my validated cells to suggest items in the validated lists based on texts typed in so far. All suggestions are welcome. Thanks

Hi, I've encountered a very frustrating situation after conquering what I thought had been the hard part of my project. I spent a good part of today looking around on Google and this forum in search of a solution without having any success, so I'm hoping someone can give me a hand! What I'm...

Hello all, I am new to the forum and this is my first post. I will try to be as specific as possible with the description of my goal. Many thanks in advance! I am trying to contro the daily intake of products at my store. The warehouse receives between 40 and 50 individual pieces of equipment...

Hi there, new to this forum so sorry if this thread goes against any guidelines or anything :p I am creating a spreadsheet system for storing student grade data, and I need to be able to select from a list of 240 students, who are all in different year groups, then form groups (e.g. 7a), then...

i have an excel template that requires people to make choices using drop down lists. how can i email this template in the message body so that the recipient can then choose from the drop down list and then submit by email. i know i can send them the file as an attachment, but i want to send it...

Hiya! Hope y'all can help me again!! I have a list of Projects, WBS codes, and BLI codes. I'd like to create a budget planning spreadsheet for multiple project managers to use for their annual planning. Instead of sending out customized templates for each project manager, I'd like to...

I am endeavouring to create and store a dropdown list in a worksheet cell as opposed to using the traditional excel 2007 methodology. The list currently contains seven items. I have played with a few lines of code and cannot seem to get it to work. Also, I would like to be able to wrap the list...