Reg need auto filter excel formulas

[psivanpandi]

Dears,
please help me for excel formula
One 20 row 20 column data range is there
first column have 3 values respective like pump,supply and ex-supply
one cell is assighned datavalidation as list like pump,supply and ex-supply
if i select the pump in datavalidation list the pump related all columns are to be past the output datarange list

If you are ready to help me please give emaild i am forwarding excel for your reference

Thanks and Regards,
P.Sivanpandi,
(e-mail address removed)

 

[alow]

Not that I don't trust a file from you, I don't trust files from anyone. I don't think you'll find someone here who will accept a file from you to view. If you could give an example in here and a little more description, I'd be glad to try and help you out. Also, what version of Excel are you currently working in?