To maintain the color formatting, highlight the bottom two rows of the
template, click on the small box in the bottom right corner of the last
cell and drag this down as far as desired.

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393949