Asaph Y.
asked • 10/06/20Building a dynamic table in excel based on dropdown lists options
I need to create a fitness training program that contains 4 dropdown lists (Program 1-3, Phase 1-3, Week 1-4, Day 1-5) and that each possible combination of these variables will retrieve a different workout (Every workout will be displayed in the same table that contains 6 columns for exercise name/sets/reps etc.)
What is the fastest and most efficient way to achieve this?
More
1 Expert Answer
It can be done with Visual Basic or VBA...
you got 3*3*4*5 = 180 possible combinations...
I strongly suggest and encourage you to explore other
hosting software other than EXCEL.
The result is a table which can be displayed in Word, and HTML, or
practically any other medium.
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
Karina A.
You should consider either building this table in WordPress or any programming software like Java if you want this into a website or phone app. Thank you10/18/20