One way would be:

Prior to changing the data in your table, do a Copy/Paste
SpecialValues for all rows previously populated. Then they will no
longer "lookup" in your table.

Another option:

Copy your table, make your changes in the new table and adjust the
formulas to that new table for any new entries. This formula change
could be fairly easy if you name your table ranges as 'Table1',
'Table2' or similiar. You could then simply highlight your desired
range of formulas to update, and use FindReplace to Find 'Table1' and
replace with 'Table2'

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473867