I see your problem, what of the formula, can you copy these to hidden
rows and re-copy the formula back after you copy-shove the data ?

Otherwise I'm not much help


Fossil_Rock Wrote:
I'm using the copy and 'insert copied cells' funtion, which pushes old
data to the right. Then I update the data in the newly 'inserted' area.
The area that needs to stay 'static' gets its data from the 3 sets of
data to the right, so the fourth set (previously the third set) is no
longer used. The older data becomes a 'history'.

The data is always going to come from the same cells and these are
rather large tables so updating the calculations takes some time.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=392474