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 Wrote:
I need to have a calculation look at a certain 'static' group of cells.
When I move the data to different location (which is needed) and new
data is put in its place, the calculation follows the data that moved.
I need it to always look at the same cells regardless of what happens
with the data.

Make since?

Hope someone can point me in the right direction,

Fossil


--
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