Inserting column and then categorising

[Dilname]

hello All ,

i am new to Macro creating , need your help in filtering and categorizing data for my work. in Sheet1 i need one column to be added where the data to be categorized by region ( Asia, Emea, Amers, Global) and categorization comes from column 'K' if the column contains as below, if nothing of below then its " Release". if two region are combined then it is Global.could any one help please.

CI Region
______________
SG Asia
HK Asia
TK Asia
SE Asia
SY Asia
UK EMEA
FF EMEA
DTC EMEA
GVA EMEA
CC AMERS
NJ AMERS
OCP AMERS
HDC AMERS
LN EMEA
SG,HK,TK,SE,SY,UK,FF,DTC,GVA,CC,NJ,OCP,HDC,LN Global

[natefarm]

I'm not seeing any of the above data in column K. Perhaps column H, but it's different than above also. And what would it look like if two regions were combined?

[Dilname]

I'm not seeing any of the above data in column K. Perhaps column H, but it's different than above also. And what would it look like if two regions were combined?

sorry to confuse you , in column 'K" we have sytem name situated in different region so what i am looking to do is to categorize theses as per region

in 'K ' it is as below
ntcs-ddndch701a,ntcs-ddndch701b,ntcs-ddndch702a,ntcs-ddndch702b-----------------contains ntcs which below to "America region "
hk1p-ddnmcva14a,hk1p-ddnmcva14b,sg1p-ddnmcva14a,sg1p-ddnmcva14b--------------contains HK which belong to " ASIA region "
dtc-ddnmcva14a -------------------contains DTC which belong to " EMEA region
hk1p-ddnmcva14a,dtcp-ddnmcva14b,sg1p-ddnmcva14a,sg1p-ddnmcva14b, NJ2-ddnmcva1-----------this contains all region which will belong to " Global"

[natefarm]

Here's my interpretation of what I see above:

The data in column K contains comma-separated values. The first two letters of each value can be used to determine the region. If all the regions in the cell are the same, then that is the region. If there are different regions, it's Global. If there are no regions, then it's Release.

Based on that, put this in a code module:

Please Login or Register  to view this content.

Then, in a column of your choice, put a "Region" heading in row one. In row two, put the formula

Please Login or Register  to view this content.

and drag it down. You can then filter, sort, or whatever, based on the Region column. You can adjust the Select Case region values any time you want.

[Dilname]

thank you so much for your help its working well !

[Dilname]

sorry i have one more doubt on the function
when i pull down the formula it just copy the first data till the end. until i edit and press enter the formula doesnot work , it basically takes the first cell data . could you please help.

[natefarm]

Your calculations are set to Manual. Switch them to Automatic (Formula tab - Calculation options).

[Dilname]

thank you its working