You could do this... in column A, on the same row that has your 12 day total,
type something like "Unit 1 total". On your summary page, type the same
title and then use a VLOOKUP, or a SUMIF to bring the total over to the
summary. Since you are inserting cells (or rows) don't lock the arrays in
the formulas and they will pick up the total line as it moves down the page.

"ledzepe" wrote:


Oh... each unit have their own sheet, example unit 1 is identified as
sheet "Unit1", and so on...


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=495556