Dependent drop down list for multiple cells


Dependent drop down list for multiple cells



i want to create a Dependent drop down list in excel and i have a small doubt in it.i have one main table and one dependent table,Main table have 6 choices and in that 6 only one choice need dependent drop down list,when i create the Dependent drop down list,it work for only one cell,but the choice may repeat may times and i need to select Dependent drop down when ever the choice selected in that coloumn.
I used formula for DDD list is =INDIRECT(SUBSTITUTE(B2," ","")),My doubt is how can i select B2 to B1200,and when ever my choice repeat, i need Dependent drop down list should come,Hope my Question has understandable .



I Have a table shown below



Booking confirmation
Booking update
Booking cancel
Loadlist/SE File
SLI Reviewed
Other updates
Cargo receipt
On board
Sailing schedule



and i have Dipendent table only for Other Update 6th one in above order



Vessel Rollouts
Loadlist revision
no update found



when i select Other update in main table for example A2 cell,i can manage to get Dependent Dropdown at B2
if i need the same in B5/B10,B12 like that, how can i proceed,All examples in internet showing only one entry
like example =INDIRECT(Aenter image description here3) or =INDIRECT(SUBSTITUTE(A3,” “,”_”))
my main question is,if i want the same to repeat in A5,A7,A8,A10 Then how can i proceed.





Not sure what you are trying to explain - you could show an image of what you want to achieve, but you could also search on here for existing solutions which might help you such as : stackoverflow.com/a/51090963/4961700
– Solar Mike
Jun 30 at 20:11





techrepublic.com/blog/microsoft-office/…
– JGFMK
Jul 1 at 11:20





Kindly advise..
– Mastan Shaik
2 days ago









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

C++ thread error: no type named ‘type’ MINGW

C++ thread error: no type named ‘type’ MINGW I'm currently doing a project for my operational systems class and I have to make a program to find prime numbers to run in threads. So I did this: #include <iostream> #include <cmath> #include <thread> #define THREADNUMBER 100 using namespace std; int CONTADOR = 0; int CONTADORTHREADEXECUTADA = 0; int primeRange(int v1, int v2) { int a, limit; bool isprime; for (int i = v1; i <= v2; i++) { if (i % 2 != 0 && i % 3 != 0) { isprime = true; limit = i / 2; if(i == 1) isprime =false; limit = (int)sqrt(i); //General case for(a=2; a <= limit; a++){ if(i % i == 0 && i != 2){ isprime = false; break; } } if (isprime) { CONTADOR++; } } } CONTADORTHREADEXECUTADA++; return 1; } int main(int argc, char *argv[ ] ) { int number1 = atoi(argv[1]); int num...
Read more

Decreasing a static image progress bar horizontally in SDL

Decreasing a static image progress bar horizontally in SDL In my project, I have a decreasing timer progress bar PNG image on display. This image and its background can be found at the below link: https://s3.eksiup.com/df7dd38f781.png My goal is to make the bar decrease starting from the upper green side to the lower red side. My code for this is the following: void EntityTimer::OnRender(SDL_Renderer *ren) { SDL_Rect currRect,dstRect; double rem=0.0; memcpy(&currRect,&origRect,sizeof (SDL_Rect)); memcpy(&dstRect,&origRect,sizeof (SDL_Rect)); if (timerObjPtr->remainingDuration>timerObjPtr->durationInMilisec) timerObjPtr->durationInMilisec=timerObjPtr->remainingDuration; rem=((double)timerObjPtr->remainingDuration/timerObjPtr->durationInMilisec); currRect.h=(origRect.h)*rem; currRect.h = currRect.h; dstRect.x=0; dstRect.y=0; dstRect.h=currRect.h...
Read more

How to input without newline? (Python)

How to input without newline? (Python) I am trying to create a simple file editor in Python via the console (called PyCons). Here is my current program: def PyCons(f): file = open(f, "r") appe = open(f, "a") print("n=====nPyCons Editor, v1.2nPython 3.6.1n") global i i = 0 for line in file: i += 1 print(" {}| ".format(i) + line, end='') for k in range(10000000000000): print("n {}| ".format(i+1), end='') inp = input("") if inp == "@PyCons.save()": print("n=====") break else: i += 1 appe.write("n" + inp) I used the end method to make sure that the existing code in the file was printed properly in its line format, but the input function does not have an end attribute. So, when I go to enter code in the editor: end input end PyCons("magic.html") ... ===== PyCons Editor, v1.2 Python 3.6.1 1| <p>Hello!...
Read more