Have a look here for Invoice 1.2.xlsx

https://app.box.com/s/23yqum8auvzx17h04u4f

Note how I defined "EntryType", "LastCell", and "HdrRow" in
NameManager.

I'm tempted to rework this but I'll refrain. I recommend you rescope
all your defined names not used in DV lists to sheet level on Invoice
so you don't get name conflicts if Invoice becomes a template. Also,
I highly recommend using JKP's NameManager addin!

I revised the grand totals formula as follows...

=SUMIF(EntryType,"Total",OFFSET(EntryType,0,COLUMN ()-1))

...so 'HdrRow:LastCell' is only used for subtotals.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion