Tables, How do I make new info push existing info to the next row?

[PeteL]

[Otto Moehrbach]

Provide more detail about what you are wanting to do. For instance, where
is the new info coming from? User entry? By VBA code?
You would need VBA to insert a new row or rows above the existing data.
For instance, the following inserts a new blank row above the current row 2.
HTH Otto
Sub Test()
Rows(2).EntireRow.Insert
End Sub
"PeteL" <PeteL@discussions.microsoft.com> wrote in message
news:87D6788F-CA5F-447F-BAF3-7821BF7DF6AB@microsoft.com...
>