Double-clicking a cell to copy filtered data in 1 worksheet to a new worksheet

[sbowers9191]

I'm trying to create a VB script in excel to filter data in another worksheet and then copy the results to another worksheet. I want to be able to click in the cells with different headings N11, N13, N15 as shown in Fig1: Fig 1: Cells to hyperlink

to filter the worksheet as shown in Fig2 to Site, Asset, Fault: Fig 2: Data to be filtered

Then copy and display the filtered data in another worksheet as shown in fig3 New Worksheet and worksheet names

Any help would be greatly appreciated.

Thanks

I have tried accomplishing this using several scripts people have kindly uploaded to here but cannot tweak the code to fit my requirements.

 

[kevin9999]

Could you share your file via Google Drive, Dropbox or similar file sharing platform, so we don't have to recreate your workbook to test possibilities.