Macro to filter a huge dataset

[zilem]

Hi,

I am working on our company's accounting code list. In my worksheet I have our accounts in one sheet (with ID, name and so on), and a data extract of our ledger in another sheet. I want to have a link beside each account code that says "example" or "link" (never mind the name), that when pressed reorganizes/filters the data extract in sheet2 so it only shows the lines of information for the specific account. I have included a template excel sheet just to show the basic layout, in case my explanation proves lacking.

Is there anyone that could point me in the right direction?

[tigeravatar]

zilem,

Attached is a modified version of your example workbook. Each cell that you wanted to be a link, I turned into a hyperlink to Sheet2 cell A1. Then I used a Worksheet_SelectionChange event in the Sheet1 event module to achieve the desired results with the following code:

Please Login or Register  to view this content.

Is something like that what you were looking for?

[zilem]

zilem,

Attached is a modified version of your example workbook. Each cell that you wanted to be a link, I turned into a hyperlink to Sheet2 cell A1. Then I used a Worksheet_SelectionChange event in the Sheet1 event module to achieve the desired results with the following code:

Please Login or Register  to view this content.

Is something like that what you were looking for?

Wow. That was actually exactly what I was looking for. Such a short and sweet code will definitely replace the monster that I'm using (which still wasn't operating like I wanted it to). Thanks a bunch!