Diplay Records based on a Cell value

[vijay.vizzu]

Dear All,


I want to display records based on a cell value, like we do in autofiter, whenever we select records, then auto filter will display the concerned records. I can get this through VBA by using advanced filter, but i need a excel formula which do this for me. Below is my sample data


Vendor Part No Description Value

VARROC 1GC-F4213-00 FENDER 123.84

VARROC 1GC-F4211-00 COVER 500.31

SEKISUI 1GC-F4201-00 SEAT 34.13

VARROC 1GC-F4311-00 SEAT,LOCK 15.13

SEKISUI 1GC-F4300-00 LOCK 12.13


if i select Varroc in cell A1, then From A2 it should display the three records like below

Vendor Part No Description Value

VARROC 1GC-F4213-00 FENDER 123.84

VARROC 1GC-F4211-00 COVER 500.31

VARROC 1GC-F4311-00 SEAT,LOCK 15.13


If any help appreciated


Regards

Vijay

 

[Hui]

Vijay


Have a read of this post by Luke which describes such a technique using formulas

http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[vijay.vizzu]

Thank you Hui, let me check it and will reply

 

[Debraj]

Hi Vijay,


When you return from that page.. you will know : How to display record for VARROC when more than One record exits..


But regarding select and AutoPupulate the same ..I hope you need to take help with HYPERLINK or CELL("Content").. but again.. with each click you need to press F9.. otherwise it will not reflect.. and you have to go "VBA-Paradise"..


Please let us know.. how do you like to go..


https://dl.dropbox.com/u/78831150/Excel/Display%20records%20based%20on%20a%20cell%20value.xlsm


Regards,

Deb