No prob, good luck with your re-design !

But do note that there are 2 things that could be done to keep things
manageable / workable

1. Set the book's calc mode to Manual

Click Tools Options Calculation tab Check "Manual" OK

Then we can press F9 to recalc only as and when required, eg after all the
daily new data entries, data updates, etc are completed. In this way the
calc/recalc won't auto-kick in after each data entry and we can complete all
data entries etc easily w/o fuss.

2. Use the smallest range sizes possible in the array expression. The larger
the range sizes, the slower the recalc.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mpenkala" wrote in message
...
Hey Max (and other readers),

just thought I'd post and say that I ended up scrapping this layout as the
formula Max wrote slowed down my computer too much. Could just be me and
my
crappy computer (cause the formula does work great).

I've tried simplifying the table and hopefully will get an answer on my
NEW
problem soon!!

Thanks again all!
Matt