I am not trying to preserve the row above it. Different information is being
pulled from each sheet into a shummary sheet so the set up is different.
Thank you for taking the time out to reply anyway.

"TomPl" wrote:

There is, i believe, a better way to accomplish what you want to do and it
does not require the use of a macro.

On each of your data sheets, select the entire last row. Right click and
copy. Right click and "Insert Copied Cells". All of your formulas have been
changed to the next row. You only need to insert the correct new data in the
last row and you have preserved the previous data in the row above it.

You can also expedite this process by selecting all the the data sheets
before performing the inserted row and you will only have to do it once.
Don't forget to deselect the grouped sheets before correcting the data in the
last row.

I hope this makes sense and help you.

Tom