Copy data if value on a fix column met

[miners]

Hello everyone,

I was wondering if anyone in the forum can help me with a vba code for this problem below:

i have a dataset A1:E9, where A2:A9 is the object names and the remaining column (B2:E9) is the value of the object in the same row.
The object ID in A2:A9 has various names, and i want to copy certain data value from B2:E9, for only certain object name.
On the file attached i only want to copy data in Column C & D ( in the same row) of certain object name & then paste the data in to different working books.

I would really apprecaiate your help & thanks in advance
Miners

[rwgrietveld]

You can do this with advanced filter

[miners]

Thanks for your response rwgrietveld,

since i'm a newbie to VBA, could you plz give me the example solution (VBA code w/ advance filter) for the file i had attached

Thanks,
Miners

[rwgrietveld]

No VBA requird. Is my book2.xls not clear?
See data->Filter->Advanced Filter and copy the settings I've made.

[miners]

Thanks rwgrietveld,

It's clear now.

Miners