Hyperlink count value back to Data

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Dear all,

    PLease review the attachment and code it carries in it.

    This code counts the data from sheet2 and stores it in 'Count' variable and in-turn inserts that value in sheet1 (D3).

    I was this D3 value (Basically count value) to be hyper-linked to Data it counted. Is it possible to achieve..?

    My basic intent is, if the user clicks on this value (hyperlinked) he must get all the data of that count.

    This is first time i am trying this kind of, kindly help.
    Any alternate suggestions are most welcome.


  • Re: Hyperlink count value back to Data

    I wouldnt do it like that. I would use a Pivot table (no macro required). This gives you the reporting automatically and gives the functionality you are looking for (clicking on the numbers to show the data in more detail).

    See attached.



    There are 10 types of people in the world. Those that understand Binary and those that dont. :P

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!