The idea of a second worksheet is good, if created with a macro
for display printing purposes with values only, but that is not what
is done in Guarantee2RowsAfterA_values which you will
find at http://www.mvps.org/dmcritchie/excel/insrtrow.htm#morex

You can rerun it and it will not insert additional rows,
but it won't delete any if you already had too many (3 empty rows)
between.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lee Harris" wrote in message news:FErff.4659
couldn't you add a 2nd worksheet where every 3rd row references the contents
of consecutive rows in the original sheet, do that for a couple of rows and
then auto fill down the page?