Fill-in rows with specific value by conditoning.

S

Steve

i have a list let say...

column a column b
-------- --------
1 898, 896
2 894
3 880, 870
4 860, 850, 840
5 830-800

input cell = (a numeric value, 1-5)

here is what i want to do.

if i enter 1 in 'input cell', then

column z
--------
898
896

if input cell = 2, then

column z
--------
894

if input cell = 4, then

column z
--------
860
850
840

etc.

is there a easy way to do it?

thx in advance.
 
D

Dave Peterson

I bet it could be done with a little more info.

Is A1 your only input cell?
Is Z1:Z??? your only output range?

What happens if you put a 1 then change it to 2? Do you clear out the first set
of values?
 
Top