Copy and paste absolute reference

[lea]

I have cells with absolute reference formulas within a table, referring to
cells in that table, how do I copy the table further down the worksheet, or
to a new worksheet with the absolute references referring to the new table
and not referring to the cells at the top of the worksheet

 

[Gord Dibben]

Un-absolute part of the reference.

i.e. $A$1 will remain that as you copy down.

$A1 will increment to $A2 $A3 $A4 etc.

A$1 will become B$1 as you copy across.


Gord Dibben MS Excel MVP

 

[lea]

Thanks Gord, works wonderfull

Un-absolute part of the reference.

i.e. $A$1 will remain that as you copy down.

$A1 will increment to $A2 $A3 $A4 etc.

A$1 will become B$1 as you copy across.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

You can post the workbook at one of the hosting sites below.

http://www.freefilehosting.net/
http://savefile.com/

When you have uploaded to that site, post the URL so we could download should we
choose.


Gord Dibben MS Excel MVP