Macro to find individual divisions then copy info

Hi All

I am comfortable with getting a macro to copy & paste where I need it to, however I am struggling with how to get the macro to recognise when a certain value has stopped.

For example in Column B on "DataDrop" are all the divisions that exist in my company i.e East Anglia, Essex, London etc. There is an empty row between each division.

I need the macro to look for the division name, sort into alphabetical order, copy & paste all the stores that come under that division (the number of stores alters each month) to ".2" B287 downwards and ".1" B3 downwards. There is other pasting that I need it to do but I can write the macro myself once I know how to get it to stop once there is a gap in the rows. i.e cells B2 to B32 for East Anglia, B34 to B75 for Essex.

The division names never change each month if that helps.

To summarise I need how to write a macro to recognise a blank row, stop, copy & paste then start from the next division down and so on. When pasting the info I also need it to know to start from the first available cell after the previous info pasted. If this is not possible I will have to just set up different areas on a worksheet to cover all possibilities.

Sample November Targeting Tool.xlsm

Thanks in advance
Mark