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 Wrote:
One way is, instead of using Cut and Paste, try Copy and Paste, then
paste the new data over the now copied set, but watch the copy area,
you need to paste a new area the same size over the old (moved) data
(or clear some additional cells)


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