Extract unique values records across multiple sheets

Hi guys

Thanks for looking. I have attached a workbook where I have manually produced the desired output. This isn't very efficient and I thought that someone may already have something similar to what I need!

In A2 of the Summary ws I would like to achieve a unique list of Party id's from Col A of the ws' "Paywall", "Leads Website" and "Newsletter".

Some Party id's may appear in multiple ws' in which case I'd only like them to appear once in the "Summary" ws.

Many thanks for looking

Cheers

Hi Nilem - спасибо. I'll try it now and post back спасибо once again!

Он работал - спасибо за вашу помощь..

That worked perfectly and in seconds. Many thanks for your time. Very kind of you.

Hi Nilem, many thanks for responding to my pm and for your help.

I have attached the WB with the question as it makes more sense there!

Hi Nilem, sorry for the delay in responding... I have to go for another meeting now but in 10 mins i'll try it and post back to let you know how it went..


Thank you so much for looking at this and for your pm. Most kind

WOW! that is amazing!! you have saved me a lot of time! incredible!!! thank you so much

EDIT NOTE: Sunday 15.03.2013: Important corrections to Green Comment notes on “Match On Error Pair” Technique, base on learning’s in Thread: http://www.excelforum.com/excel-new-...err-clear.html

Originally Posted by Blake 7

......
In A2 of the Summary ws I would like to achieve a unique list of Party id's from Col A of the ws' "Paywall", "Leads Website" and "Newsletter".

......

Hi Blake 7,
. I was attempting my “Beginner’s” solution to your problem as the Profi did his already
. But as I find Threads where more than one solution is given extremely helpful in my Learning of VBA, I thought I would include it anyway. I guessed at the time that you actually wanted finally to produce a Summary Sheet and was working on just such a solution. Nilem’s final brilliant solution confirmed that. I expect I will be taking some time to understand his code. It is clearly a fast Profi Solution.

. Here is my code, which appears to give the same results as Nilem’s

Please Login or Register  to view this content.

. Basically this code produces an additional Sheet with all data in it. It then makes a another Summary Sheet and copies only Once Rows to it from the Full Sheet with a specific party ID

. Here is my File.
https://app.box.com/s/7m4euu5er49h6gev70nb0whlqwee8hty
But I am sure Nilem’s solution is the one to go with.

Alan

Hi Alan - your response is much appreciated, and by the sound of it you also achieved some satisfaction! i'm at home now and with the children so i dont have time to play with it! but at 9 am tomorrow i'll be giving it a whirl. Yes Nilem looks like a master of VBA but this takes time I guess!! I am far far behind you my friend!! All the best and i'll be in touch tomorrow!

Hi Nilem, and thanks.

My question is...!!

If i wanted to add another ws to be included in the summary do i need to amend the code or just add a ws with the same column headings??

I appreciate that you are busy and may not have the time/inclination to answer beings that you have already helped me so much but thought it worth asking!

FYI I have uploaded the WB so you can see why i needed what I did! -- see cols H:L of ws Final ,,, this is what your code helped me to achieve! I can now see one one row. which products a customer has engaged with!!! now I will give engagement scores!!! yeyyy!

Thanks to you!!

Perfect - this is just what i needed as I needed to add another sheet! excellent -- many thanks again.

Hi N, I just added another sheet and it worked great. Thank you. Really nice of you to upload a file too containing the code with instructions. Really helpful!!!