Multiple functions

[janmelnick]

I have a table that has approx. 6 columns. There are about 30 rows
each with a different scenario (ie 5 in column 1, 0 in column 2, 5 i
column 3 etc).

I want to be able to input values on a "front" sheet, that will the
bring me back each of the scenarios. ie Scenario 1 is 5 0 5 etc.
know I will probably need multiple functions but aren't sure which. A
I am a novice, please could you use laymen's terms.
Thank

 

[janmelnick]

I have a table that has approx. 6 columns. There are about 30 rows
each with a different scenario (ie 5 in column 1, 0 in column 2, 5 i
column 3 etc).

I want to be able to input values on a "front" sheet, that will the
bring me back each of the scenarios. ie Scenario 1 is 5 0 5 etc.
know I will probably need multiple functions but aren't sure which. A
I am a novice, please could you use laymen's terms.
Thanks

I was finally able to resolve this by running an Advanced Filter, the
I added and object, assigned a macro that refreshed the filter each tim
you changed details and clicked button. Well happ