I don't understand why you'd want to add a row, then delete another. Why not simply migrate the data from the existing lower rows and leave the lowest row ready for the latest data to be input?

There's no problem with cross-posting, per se. All that is asked for is that you provide the links so people don't waste their time covering ground that's been covered elsewhere - and so that anyone who might find your thread here while searching for a solution to a similar problem can find where/how it was resolved, if not here.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]