I have a list of Suppliers and Primary postcodes.
Say the postcode was BA the start 1 and end 3....that means that particular supplier covers postcodes BA1 BA2 BA3.
I need to manipulate this data so instead of having "BA start 1" end 3 i have a row for each.
I know i need a macro to do this as im proposing expanding the 35000 postcodes to an even bigger amount.
I've attached a example doc.
Bookmarks