Cell references

  • Thread starter Thread starter gary
  • Start date Start date
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
 
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
 
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
 
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$
 
Back
Top