Try posting your top cell formula ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fredw" wrote in message
...
While shortening the sheetnames would indeed decrease the invidual parts
of
the formula, but at 1,500 lines, the formula will still to be too long for
an
single cell. I am thinking "vlookup", "sumif" or something that would
encompass a "range" is the direction that I need to head.

Thank-you for the reply,
--
gen_chang