Insert an empty row above your existing data. Change your formulae so
that they include this row then hide the row. Then when you insert
more data it will be inserted between the existing data and the hidden
row.


--
millsy
------------------------------------------------------------------------
millsy's Profile: http://www.excelforum.com/member.php...fo&userid=5122
View this thread: http://www.excelforum.com/showthread...hreadid=535037