Thanks alot, when i copied my old data back into the spreadsheet i
fubar'd the cell refs in the formula for the rest of the table. I mad
the alteration you suggested and voila, we have lift off.

Thanks again, you don't know how long this has been aggrivating me!!

Cheers,
-Dave Corve

--
cynder7
-----------------------------------------------------------------------
cynder77's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=26991