matching entries in two columns and retaining corresponding observations only

[Abhi88]

Hello,
I have excel sheet containing around 100K observations (rows).
There is one column say "A" containing some IDs and each ID is having 10 parameter values (say in columns "B" to "K"). Now, I have another column say "AA" containing IDs (around 1K) which I'm interested in filtering from those 100K. Is there any way so that I can filter these IDs and retain their corresponding parameter values in one go?




<config>Windows 7 / Chrome 48.0.2564.103</config>

 

[Abhi88]

Hello,
Just to let you know I referred your vba code on other post (http://www.mrexcel.com/forum/excel-...cations-find-match-then-copy-paste-range.html).

I want to know is it possible to copy duplicate values also using this code and if not, what modifications should be done?