Select Case Code Needed

[HYKE]

Hello,

I have the following list of countries now I want to group according to region, then cluster classification and according to salesman. I am thinking of using select case but I do not know if 3 criteria is possible.

As below is the structure

Countries: ( Column A )

Bahrain
Iraq
Jordan
Kuwait
Lebanon
Oman
Palest. Terr.
Qatar
Saudi Arabia
U.A.E.
Yemen

Region ( Column B )
Gulf

Cluster : ( Column C )
Indirect


Salesman: ( Column D )
Salesman1

Countries: Column A
Benin
Cameroon
Centr.Afr.Rep.
Chad
Congo
Dem. Rep. Congo
Djibouti
Equatorial Gui.
Frenc.Polynesia
Gabon
Guadeloupe
Guinea
Guyana
Ivory Coast
Mauritania
Morocco
Niger
Tunisia

Region ( Column B )
French Africa

Cluster : ( Column C )
Direct


Salesman: ( Column D )
Salesman2

I hope you guys can come up with a really nice macro code for me as you all always have...

Thanks!

HYKE

 

[jolivanes]

I don't quite get what you're after but the multiple criteria is certainly possible.

For Each MyCell In Rng
With MyCell
Select Case True
Case .Value = "Hallo" And .Offset(0, -1).Text = "10""" And .Offset(0, -2).Text = "15""" And .Offset(0, -3).Text = "20"""
    'Do what needs to be done here
Case .Value = "Hallo" And .Offset(0, -1).Text = "10""" And .Offset(0, -2).Text = "15""" And .Offset(0, -3).Text = "30"""
    'Do what needs to be done here
etc etc
End Select
End With
Next MyCell