The coding is basically the same thing (just different rows).

What I was trying to get was why it just seems to read the very first
line of each subsection and hides the following rows based off of that
line.


Your idea for entering data into another worksheet will not work. And
the assumption of "different" looking invoices is wrong. It's all the
exact same appearance.

Column "Z" is the line totals (also the column that carries the
subtotals and Total)

There are validations, formulas, and dropdown lists from Columns A thru
Y. In addition - the worksheet that users use are tied into two hidden
worksheets involving more formulas, IFs, etc.

Thanks,
Sarr

P.S. Coding is a lot longer - the first post was just the first
section so that the reader of this will know what I'm writing.


--
Sarrina
------------------------------------------------------------------------
Sarrina's Profile: http://www.excelforum.com/member.php...o&userid=22337
View this thread: http://www.excelforum.com/showthread...hreadid=379002