Hi,
I have two sets of data, one is a column with a certain set of numbers, lets say
11111
33333
55555
Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this:
11111 abc
22222 def
33333 ghi
44444 jkl
55555 mno
I need to somehow filter the second set of data so that i find the results based on the numbers in the first set. my results would be
abc
ghi
mno
i have been doing this by filtering the first column of the second set of data using the data found in my first set, and then copying and pasting the results in the second column of the second set.
how would i go about finding these results using vba code?
any ideas are helpful and thank you in advance!
I have two sets of data, one is a column with a certain set of numbers, lets say
11111
33333
55555
Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this:
11111 abc
22222 def
33333 ghi
44444 jkl
55555 mno
I need to somehow filter the second set of data so that i find the results based on the numbers in the first set. my results would be
abc
ghi
mno
i have been doing this by filtering the first column of the second set of data using the data found in my first set, and then copying and pasting the results in the second column of the second set.
how would i go about finding these results using vba code?
any ideas are helpful and thank you in advance!