select rows based on different cell

[hcacote]

Hi,

I would like to copy several rows based on the match of several
possible cell to another spaces in the worksheet

eg: the cells that I want to match
A
1 ¦ Part A
2 ¦ Part B
3 ¦ Part C
4 ¦ Part D

A B
6¦ 111 Part A
7¦ 112 Part B
8¦ 113 Part A
9¦ 114 Part K
10¦ 115 Part F
11¦ 116 Part D
12¦ 117 Part A

I would like to have has result the following:

A B
6¦ 111 Part A
7¦ 112 Part B
8¦ 113 Part A
11¦ 116 Part D
12¦ 117 Part A

I already tried to use vlookup, match and so on but I cannot get it to
work.

Do I need to use a macro to have it done, or there is any native Excel
tool that I can use?

Thank you for any hint that you might provide
Hugo

 

[Don Guillett]

You could use Data>filter>autofilter>custom>does not end with. Record a
macro and clean it up.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Hi,

I would like to copy several rows based on the match of several
possible cell to another spaces in the worksheet

eg: the cells that I want to match
A
1 ¦ Part A
2 ¦ Part B
3 ¦ Part C
4 ¦ Part D

A B
6¦ 111 Part A
7¦ 112 Part B
8¦ 113 Part A
9¦ 114 Part K
10¦ 115 Part F
11¦ 116 Part D
12¦ 117 Part A

I would like to have has result the following:

A B
6¦ 111 Part A
7¦ 112 Part B
8¦ 113 Part A
11¦ 116 Part D
12¦ 117 Part A

I already tried to use vlookup, match and so on but I cannot get it to
work.

Do I need to use a macro to have it done, or there is any native Excel
tool that I can use?

Thank you for any hint that you might provide
Hugo