Two things I would suggest:

1. Condense your helper row from 2 rows to 1 by nesting your formula as
I suggested ie *= A2=VALUE(LEFT(A1))*

2. A feature of Excel that a lot of people don't know exist is on the
edit menu - Custom Views. You can set this up to exactly what you want
including print options.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374128