Concatenate text to make calculation

F

Fossil_Rock

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
 
B

Bryan Hessey

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

Fossil_Rock

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

Bryan Hessey

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
 
R

RagDyeR

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" <[email protected]>
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.
 
Top