Adding relevant sheets
 

I need to be able to add all the previous sheets that have a specific
text in a certain cell. For example:

Cell B12 contains a three letter reference. I want to know how many
previous sheets have the same reference.

However I do not want to know how many there are in total in the
worksheet, otherwise all the sheets will return the same number. Does
that make sense?????

So if Sheet 5 B12 reads "TSS" and two earlier sheets also read "TSS" in
the same cell, I need the number "3" returned. If I then insert "TSS" in
sheet 8, I need sheet 5 to still read "3" and sheet 8 to now read "4".

??????? complicated I think.....

Basically I am making an invoicing sheet that numbers a client's
invoices rather than numbering them all globally.

:-S


--
Gavin Ling
------------------------------------------------------------------------
Gavin Ling's Profile: http://www.excelforum.com/member.php...o&userid=30110
View this thread: http://www.excelforum.com/showthread...hreadid=497971