Dear Gurus / Friends

The solution seem fine to me, however when I used the macro with my real data, it does not give the desired results, as I explan the data is very Dynamic the regions can increase or decrease same is with other columns data. for this specific reason I am using above code (VB code on top). What I need an array forumla which can extrat unique distinct information from my data of any Column based on criteria like ABC[country]. Same feature we use in Pivot table, if I select Country "SOM" it filters all info related to SOM, but this information is unique, so the macro should copy code "120130" and 120131 in a column "summary" sheet. So I can use sumifs function to get the financial information.
summary.JPG

Sorry If I was not very clear