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


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

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

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

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

Found the solution.. Woohoooo

' =Indirect '

Thanks for your input,

Fossil


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

Say your formula was:

=SUM(J1:L1)

Revise it to:

=SUM(INDIRECT("J1:L1"))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Fossil_Rock"
wrote in message
...

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