Help with inserting rows in excel 2007

[deathsarmour]

Hi

I have searched the forum but can’t find anyway to solve this. I have a document at work that lists all the individual items that clients send into us. Each item is given a unique number and is listed by the client that sent the item in and the property the item came from. I am using formulas to determine the number assigned to each item but would like to use a macro to insert a row to separate the different addresses. However the number of items that comes from each address is variable. (as this is a bit confusing I have added a before and after to show what I am trying to achieve.

What I am hoping is that the number entered into column G Can be used to determine where the new row is placed.


I have a fairly good knowledge of excel but I am only mediocre when it comes to Marcos. Can anyone help me out?

Kind Regards

Duncan