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

	B	C
1	4 x 8 Merged With C1
2	Load	Reps
3	75%	8
4	75%	8
5	75%	8
6	75%	8
7
8	3 x 10 (merged with cell to right)
9	Load	Reps
10	65%	10
11	65%	10
12	65%	10

<tbody>
</tbody>

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.

Exercise 1	Load	REPS
(Drop Down Select 4x8)	75%	8
	75%	8
	75%	8
	75%	8

<tbody>
</tbody>

If selected 3x10

Exercise 1	Load	REPS
(Drop Down Select 3x10)	65%	10
	65%	10
	65%	10
	(blank)	(blank)

<tbody>
</tbody>

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