• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unique record Link

P

Pitcher

Member
Hi guys,


Hoping someone can help me with this one!


I have a large data set on one worksheet whereby I have multiple names list several times in one column and what I want to do is create a link of these names to another worksheet but only want link unqiue records only.


Understanding I can use unqiue filters etc I want to automate this so that whenever I update the data set there is no nede to take an action.


Any ideas?


Thanks,

Andrew
 
Hi Andrew,


Can you please download the below file and check.

use Control+Q to run the macro. check in sheet2 will have only the unique numbers.


http://www.2shared.com/file/eThTZWvm/5_online.html


Thanks,

Suresh Kumar S
 
Hi Pitcher,


Your problem is still not clear to me.


You have a duplicate list. On some other sheet you have only Unique name?? What is the purpose of this Hyperlink. Can you explain it with an example or upload sample file??


Please see this file, am i correct in my approach:


http://dl.dropbox.com/u/60644346/MovingHyperlinks.xlsx


Regards,

Faseeh
 
You must log in or register to reply here.
Back
Top