Deleting rows with data from columns matching

Closed
Travis - Oct 13, 2010 at 01:01 AM
 mile - Oct 16, 2010 at 09:00 AM
Hi there.

Im trying to look for a Macro that will do the following.

I have a large data set with a range of numbers.
I would like to search though a set column of worksheet "A"
and delete ALL matching values that are found in a set
column in Worksheet "B" by row .

Worksheet A
1
2
2
3
3
4
5
6
2
2
2
1
3

Worksheet B
1
2
3
4
5

So, I would like the Macro to run through each cell
value in Worksheet B (eg:1), and match ALL values of 1
in Worksheet A and delete the whole row.
Then continue to Worksheet B (2) and delete all values of
2 in Worksheet A. Note, the values in Worksheet B will change each time
I will use this Macro, so its not the cell value (1 or 2), but rather the cell (A1, A2) itsself I want to match.

Does this make sense??

Many thanks for any assistance that anyone might give.

Related:

1 response

hi idont have answer but i want to friendship with u
0