Help needed for linking hperlink with filtered data across sheets

**ashtest** · 05-14-2012, 05:35 AM

HI -

I have attached my work book sample. What i want to do is when i click on the cell under "Pass" n sheet 2 it should take me toSheet 1 and display only row number 4 & 9 information i.e. the details of the IP's which have passed in cycle 1.

I will be extending the logic to other status( Fail,On Hold etc) as well

Thanks for help!

Ashwini

**JBeaucaire** · 05-14-2012, 08:48 AM

You can do this manually (and quickly) on sheet1 without needing sheet2 at all (or VBA, for that matter):

1) Click on A1:H1
2) Select Data > Filter and your AutoFilter arrows will appear
3) Now you can Autofilter column H any way you want.

You can also record a macro of you filtering for "PASS", then attach that macro to buttons/cells on sheet2 if you wish. Repeat for other values.

**ashtest** · 05-17-2012, 05:30 AM

Hi -

I know the manual way to do this, but I have copy pasted only a part of my workbook for the reason of keeping the file size low. Yes I have recorded a macro on filtering "Pass", however I need the code to assign the macro to the cell and make the macro run only on double clicking the cell and not single clicking it.

Thanks,
Ash

**JBeaucaire** · 05-17-2012, 12:29 PM

There is a worksheet event called Worksheet_BeforeDoubleClick. You can use that 'event' to call your macro if they double click on a cell in a specific column. Read up on that.