Cell references

G

gary

My worksheet contains many "blocks" of data. Each block
is identical in size. The only difference is that the
cell contents vary in each 'block' to 'block'.

In the first 'block', I'm using formulas that
contain 'relative', 'absolute' and 'mixed' references.

I want to copy/paste the formulas to the other 'blocks'.
But the formulas need to automatically "adjust" so they
refer to the cells in each of the other 'blocks'.

How can I do this?

Gary
 
G

Guest

My worksheet contains many "blocks" of data. The "blocks"
are identical in size. The only difference is that the
cell contents vary from "block" to "block".

In the first "block", I'm using formulas that contain
'relative', 'absolute' and 'mixed' references.

I want to copy/paste the formulas from the first "block"
to the other "blocks". But the formulas need to
automatically "adjust" so they refer to the cells in each
new "block".

How can I do this?

Gary
 
R

RagDyer

Don't know if I exactly understand you.

Are you trying to eliminate the absolute and mixed references from the first
block, so that the copy paste to the second block will all reflect the new
references?
I would guess that you really don't need the absolute and mixed references
if you're going to go this route to copy, and you want *new* references.

If that be the case, you could try selecting the entire first block and,
<Edit> <Replace>
to erase the $ signs before you copy to block2.

In "Find What", enter the $,
Don't do anything with "Replace With",
And then click "ReplaceAll'.

Now, with all your formulas relative, the copy paste will change all the
cell references to match up in the second block.

Is this what you're looking for?
--

HTH,

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


My worksheet contains many "blocks" of data. Each block
is identical in size. The only difference is that the
cell contents vary in each 'block' to 'block'.

In the first 'block', I'm using formulas that
contain 'relative', 'absolute' and 'mixed' references.

I want to copy/paste the formulas to the other 'blocks'.
But the formulas need to automatically "adjust" so they
refer to the cells in each of the other 'blocks'.

How can I do this?

Gary
 
B

BrianB

It depends where you are copying the blocks - whether horizontally o
vertically when you use RowAbsolute eg. =A$1 or Column Absolute eg
=$A1.


The best way is to use *all relative* references . eg. =A1
You will need to manually change absolute references anyway eg. =$A$
 
Top