Hi Excel Gurus, I am trying to create a Dependent Dropdown List using Dynamic Arrays. When we select a client name in Column R, then column S should contain list of only related holder names. I have used dynamic array formula in each cell of range G2:G6. I tried to use SE...
Looking for your help! I have attached the copy of a file I'm working. In the list tab, you'll find a list of different vehicles split by categories (MTL, CAT, LDV, BUS). I would like to create a dependant drop down menu in the RAW DATA tab with Fleet numbers depending on the...
Forum:Excel Questions Sticky: Display Named Range contents based on text in cell Hey Excellers... I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it. What I want it to do (in sheet3, no less...
Looking for your help! I have attached the copy of a file I'm working. In the list tab, you'll find a list of different vehicles split by categories (MTL, CAT, LDV, BUS). I would like ... vitoaiacoAha! I missed that you also had a reference to C1 in ...
The permissions and tasks differ based on their role. The problem is that it has to be done soley in Word . Excel , Access etc. are not an option","body@stringLength":"725","rawBody":"Is there a way to create a cascading List or drop down list in MS Word only that either ...
Hi - I have a drop down list in column A - lets say 1, 2, 3, 4. That list relates to one of 4 sheets of data, say sheet 1, sheet 2, etc If I...
Hi Excel Gurus, I am trying to create a Dependent Dropdown List using Dynamic Arrays. When we select a client name in Column R, then column S should contain list of only related holder names. I have...Show More DepDropDown.xlsx15 KB ...