I would suggest a macro linked to the Worksheet_Change event. You could
test if the row was the last of the three, insert a new row below and
then copy/paste special formats from the original.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=559871