Now I see. Thanks!
I do like this solution but one of the issues is that the people who are going to be using this, aren't necessarily familiar with how to run macros, so I have to keep it really easy to use. Is easiest if the macro itself can prompt the user to delete or add to modify the rows.
Doug Robbins on the Microsoft forum just solved this for me:
http://answers.microsoft.com/en-us/o...=1365388494607
However, I am going to keep this solution and propose both and see what they think of it?
Thanks again!