find word starts with specific text in range

[linok]

Hello All,

I have below range:

AATest1 ABC AA
AATest1 ABC AA
BBTest1 ABC AA
BBTest2 XYZ BB
BBTest3 XYZ BB
CCTest1 ABC AA
CCTest2 ABC AA
CCTest3 ABC AA
DDTest1 ABC AA
DDTest2 XYZ BB

I want to find out below result using VBA(filter on 3 columns)

BBTest2
BBTest3
DDTest2

what is the easiest way of doing this?

[MarvinP]

Hi linok,

This looks like an Advanced Filter problem to me. If you learn a little about Advanced Filters using the "Starts With" criteria the VBA code would make more sense.

Read this site http://www.contextures.com/xladvfilter01.html and look at the wildcard criteria for the "Starts With" part.

I hope this helps you get started. If you want total VBA then Advanced Filters aren't needed. BUT you may not need VBA to get your answer if you learn the above.