Change Cell Range Based On A Drop Down

[AJ0HN]

Hi,

I am trying to create a sheet for training programmes, whereby I can select the training parameters i.e. set x reps etc. from a dropdown say 4x8.

This then updates the training programme from the parameter set out on another existing sheet.

So sheet 1 might look like this, with different parameters listed below

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]4 x 8 Merged With C1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Load[/TD]
[TD]Reps[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]3 x 10 (merged with cell to right)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Load[/TD]
[TD]Reps[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]


Sheet 2, with a dropdown to select parameter e.g. 4x8, or 3x10, etc., which changes populates these cols to the right as a example if select 4x8 in dropdown.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Exercise 1[/TD]
[TD]Load[/TD]
[TD]REPS[/TD]
[/TR]
[TR]
[TD](Drop Down Select 4x8)[/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]75%[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

If selected 3x10

[TABLE="width: 500"]
<tbody>[TR]
[TD]Exercise 1[/TD]
[TD]Load[/TD]
[TD]REPS[/TD]
[/TR]
[TR]
[TD](Drop Down Select 3x10)[/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]65%[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](blank)[/TD]
[TD](blank)[/TD]
[/TR]
</tbody>[/TABLE]

I hope this makes sense, I wanted to include a screenshot but don't think that is possible on here.

I tried this using a =VLOOKUP() but that took a while, so wondered if better way.

Thanks again,

Ash


EDIT: To be specific it is only how I might populate the rep/load cols I know how to do the drop down etc.

Example:

https://youtu.be/w_lAAeC8m7Q