I need to write a macro which will insert a new row into certain locations within my excel worksheet.

i.e. if the data in column A's changes i need to insert a new row...

For example, the first 50 rows in my column A have got the word "Boston". Then Row 51 changes to "New York". When the word changes to new york i need to add on blank row.

is this possible?