VBA Coding to create Canada postal code ranges for each tariff zone

[staceyclark2734]

I'm looking for a VBA code that I can use to create Canada postal code ranges for each tariff zone.

 

[mumps]

What do you mean by postal code ranges? Would that be A2:A3 for "CAABABEE", etc.? If so, what do you want to do with the ranges after they have been created?

 

[staceyclark2734]

Here's an example of what I'm looking for. Tariff Zone CAABACHESO has about 85 postal codes. I want it to make ranges of the postal codes in column A

T7X 6A1 - T7X 6E9 T7X 6H1 - T7X 6H2 T7X 6H6 - T7X 6H6 T7X 6H8 - T7X 6H9

 

[mumps]

Do you want the ranges listed in another worksheet?
It is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need help on converting a list of Canadian Postal code to ranges
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.