select rows based on different cell


H

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
 
Ad

Advertisements

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top