• 9 years ago
Ken Atigari shows how to create dependent drop down lists using the indirect and substitute syntax within data validation. He then programs with VBA to automatically return the list values to default.

Recommended

13:23
I
Up next
Heirarchal dropdown lists and substitute functions in Excel
Ken Atigari
10:42
Using nested IFs in Excel Data Vaildation
Ken Atigari
4:21
Some UI (User Interface) tricks in Excel
Ken Atigari
9:00
2 ways to create error bar charts in Excel
Ken Atigari
0:34
Tested: The Best Meal Delivery Services for Easy Planning
Food and Wine
0:51
Former Aide Claims She Was Asked to Make a ‘Hit List’ For Trump
Veuer
1:08
Musk’s X Is ‘the Platform With the Largest Ratio of Misinformation or Disinformation’ Amongst All Social Media Platforms
Veuer
4:50
59 companies that are changing the world: From Tesla to Chobani
Fortune
0:46
3 Things to Know About Coco Gauff's Parents
People
0:35
8 Things to Do in the Morning to Improve Productivity
Martha Stewart Living
0:47
Hayden Panettiere & Family Break Silence On Her Brother Jansen’s Death: ‘In Our Hearts Forever’
Hollywood Life
2:11
Why You Should Remember Aretha Franklin
Goalcast
1:18
USC vs. Colorado: Can Caleb Williams Earn a New Heisman Moment?
SportsGrid
1:04
Vic Mensa Reveals Celebrity Crush, Biggest Dating Pet Peeve & More on Speed Dating | Billboard News
Billboard
1:09
Hollywood Writers Reach ‘Tentative Agreement’ With Studios After 146 Day Strike
Veuer
1:26
Love is Blind stars admit they're burnt out from social media
Fortune
0:20
1-on-1 with Kyle Busch: Brexton’s future in racing
NASCAR
2:01
NHA Customers in Limbo as Company Faces Potential Merger
SportsGrid
2:55
Vanilla Ice Explains How the 90’s Shaped America
FACTZ
1:26
Hot 100 Chart Reveal: Sept. 30, 2023 | Billboard News
Billboard
0:36
Amazon’ Prime Video Will Show Commercials Starting Next Year
Veuer
1:10
Angelica Ross Spills Details on Call with Emma Roberts About Transphobic Remarks
What's Trending
11:13
Pokimane Answers The Web's Most Searched Questions
WIRED
0:20
Race Rewind: Opening the Round of 12 with a bang at Texas
NASCAR
4:16
BREAKING NEWS: Matt Gaetz Tells House Committee: 'I'm Not Going To Vote For A Continuing Resolution'
Forbes Breaking News