Difficult to Help without a workbook. Can you attach one so that someone can look into it?
I cannot as this is non public information but I can provide sample data that looks like my data.
company company hq region sales alpha france europe 10 bravo united states east 50 charlie united states west 20
Given this data how can I map out the border of regions that are either international or state level.