• 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 across multiple worksheets

P

Pitcher

Member
Hi all,


Hopeing someone can help me with this one...


I have a large data set on one worksheet and I want to link these records (unqiue only/no duplicates) to another worksheet automatically without having to use a unqiue filter etc...


Is this possible?


Thanks,

Andrew
 
Hi Andrew,


Can you please download the below file and check whether you looking this kind of output.


http://www.2shared.com/file/kRfEK3H4/u_online.html


Note:Only Unique records are moved without links.


Thanks,

Suresh Kumar S
 
Hi Suresh,


Apologies for the delayed response.


Your workbook demonstrates exactly what I want to do. Understanding that this can be done by using a unqiue filter, did you acheive this result in an automated way? If so, can you please share working or explanation.


Thanks,

Andrew
 
Glad to help Mr.Andrew,


It can be done through Unique or remove duplicates (Under Data menu).


I have used Remove Duplicates with help of Macro to have only unique ids.

(Copy the entire column (rawdata) and paste in the next sheet and select entire column and choose remove duplicates under Data Menu)


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top