There could be as few as three worksheets or as many as I feel
necessary. It is completely possible that another function may work
better and I wouldn't know because I'm pretty new at this.

Is there something wrong with the sheet1, sheet2, etc.. reference
names? I know they are vanilla, but I don't really mind at this point.
If I could figure out how to reference more than 1 worksheet in a
formula, I would probably change the name of the worksheets to reflect
the date of the data. = )

I reference the entire A column because sometimes there may be more or
less items in that column and I don't really want to have to change the
range each time. Seaching A:A covers any number of items and empty cells
are ignored so it seems to work.

I would totally agree that I may be using a less than efficient formula
due to not knowing better. I really appreciate your help though Biff.


--
ChrisPrather
------------------------------------------------------------------------
ChrisPrather's Profile: http://www.excelforum.com/member.php...o&userid=37743
View this thread: http://www.excelforum.com/showthread...hreadid=573836