Excel extraction

Closed
Pras - Jun 18, 2010 at 05:40 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 18, 2010 at 06:30 PM
Hello,

I have two excel sheets.
Sheet A with all the IDs and sheet B with volumes of IDs and corresponding datas about them. The ID values in sheet A are repeated in the sheet B.

I want to know how to extract the IDs and a particular column of data corresponding to that ID

exmaple

sheet A

ID
123
234
345
456

Sheet B

ID Name age
123 mark 23
123 ben 34
345 enw 44
345 rtg 34
999 ddf 32
888 dfjvn 34

I want the resulting sheet to contain the values like

ID Name
123 mark
123 ben
345 enw
345 rtg

Leaving the third column and having the repeated values. Is there any way I can do this?

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 18, 2010 at 06:30 PM
I think the best way would be to use macro
0