Help..! Automatic sorting by clicking a cell

[ar.ragesh]

Hi,
i am using Excel 2010,
i have two woksheets. first work sheet is index work sheet, looks similar like below

sl no Brand
1 abc More Details
2 abc1 More Details
3 abc2 More Details
4 abc3 More Details
5 abc4 More Details
6 abc5 More Details
7 abc6 More Details
8 abc7 More Details

and second data worksheet is like below

sl no Brand approval indent order request Proforma PO BOL date Delivery Date
1 abc a 8001 OR01 PI-00201 PO-500 12-12-13 01-01-14
2 abc1 b 8002 OR02 PI-00202 PO-501 13-12-13 02-01-14
3 abc2 a 8003 OR03 PI-00203 PO-502 14-12-13 03-01-14
4 abc3 a 8004 OR04 PI-00204 PO-503 15-12-13 04-01-14
5 abc4 c 8005 OR05 PI-00205 PO-504 16-12-13 05-01-14
6 abc5 b 8006 OR06 PI-00206 PO-505 17-12-13 06-01-14
7 abc6 a 8007 OR07 PI-00207 PO-506 18-12-13 07-01-14
8 abc7 c 8008 OR08 PI-00208 PO-507 19-12-13 08-01-14


so if i click sl# 4 - 'more details' cell in index worksheeet it should filter the data like below in data worksheet

sl no Brand approval indent order request Proforma PO BOL date Delivery Date
4 abc3 a 8004 OR04 PI-00204 PO-503 15-12-13 04-01-14
is it possible by using hyperlink or any other method except using macros ? please help..!

[zbor]

Not without macro.

Maybe you could use something like this:

filter out numbers you want see Detaisl (i.e. 4) and choose in B1 do you want to show or hide details.

[ar.ragesh]

Thank you very much zbor,
this is what i need, can you please elaborate, how to do this .

thank you

[zbor]

B1 is simple drop down menu.

In other cells use VLOOKUp function: If hide details show blank otherwise VLOOKUP data from other sheet

[ar.ragesh]

yupeee..! i got it... thank you