Hello Guys,
My originally table has 5 columns and 2390 rows.
This is just a sample table to explain the goal thats how to create Create Multiple Dependent Drop-Down Lists (on Every Row)?
Without VBA and with simple fuid efficiency formulas please let me know how to overtake this challenge?
Additional information please let me know.
Thank you very much.
My originally table has 5 columns and 2390 rows.
This is just a sample table to explain the goal thats how to create Create Multiple Dependent Drop-Down Lists (on Every Row)?
Without VBA and with simple fuid efficiency formulas please let me know how to overtake this challenge?
Additional information please let me know.
Thank you very much.
| Novo Folha de Cálculo do Microsoft Excel.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | |||
| 2 | MAIN TABLE | CODE | ||||||||||||
| 3 | CODE | CENTER | CITY | SPECIALITY | NAME | AA 11 | CENTER | CITY | SPECIALITY | NAME | ||||
| 4 | AA 11 | ALPHA | DENVER | NURSE | JOHN | (opens drop down list based on cell H3) | (opens drop down list based on cell J4) | (opens drop down list based on cell K4) | (opens drop down list based on cell L4) | |||||
| 5 | AA 11 | ALPHA | DENVER | NURSE | PETER | (opens drop down list based on cell H3) | (opens drop down list based on cell J5) | (opens drop down list based on cell K5) | (opens drop down list based on cell L5) | |||||
| 6 | AA 11 | CREATIVE | DENVER | PHYSICIAN | ANDREA | (opens drop down list based on cell H3) | … | … | … | |||||
| 7 | BB 13 | SIC | COLORADO | PHYSICIAN | OLGA | … | ||||||||
| 8 | BB 13 | SIC | COLORADO | NURSE | GABY | |||||||||
| 9 | BB 13 | TVI | COLORADO | TECHNICIAN | FAISA | |||||||||
| 10 | CC 20 | RT1 | DALLAS | TECHNICIAN | ERBA | |||||||||
| 11 | CC 20 | RTP2 | DALLAS | NURSE | PURA | |||||||||
| 12 | DD 02 | FOX | YORK | TECHNICIAN | EURO | |||||||||
| 13 | EE 05 | HOLLYWOOD | DUBLIN | PHYSICIAN | YGOR | CODE | ||||||||
| 14 | EE 05 | HOLLYWOOD | DUBLIN | PHYSICIAN | JAINE | BB 13 | ||||||||
| 15 | EE 05 | HOLLYWOOD | DUBLIN | NURSE | LYON | CENTER | CITY | SPECIALITY | NAME | |||||
| 16 | EE 05 | FOX T | DUBLIN | LAWYER | JASY | (opens drop down list based on cell H14) | (opens drop down list based on cell J16) | (opens drop down list based on cell K16) | (opens drop down list based on cell L16) | |||||
| 17 | FF 07 | JAM | MADRID | LAWYER | JASUS | (opens drop down list based on cell H14) | (opens drop down list based on cell I17) | (opens drop down list based on cell K17) | (opens drop down list based on cell L17) | |||||
| 18 | FF 89 | JAM 2 | BARCELONA | NURSE | OSCAR | (opens drop down list based on cell H14) | … | … | … | |||||
| 19 | FF 90 | ANK | HUELVA | POLICE | FILIPE | … | ||||||||
| 20 | FF 91 | ANK 4 | FARO | POLICE | JACQUELINE | |||||||||
| 21 | FF 92 | ANK 5 | LONDON | PHYSICIAN | ANTERD | |||||||||
| 22 | FF 92 | ANK 5 | PORTO | TECHNICIAN | SOVIET | |||||||||
| 23 | FF 92 | RTL | PORTO | NURSE | LEVIS | |||||||||
| 24 | GG 24 | RTL 2 | LUX | POLICE | C17 | |||||||||
| 25 | GG 24 | RTL 3 | LUX | PHYSICIAN | FLY | |||||||||
| 26 | … | |||||||||||||
| 27 | ||||||||||||||
Folha1 | ||||||||||||||
