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

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


On Wed, 14 May 2008 16:40:00 -0700, lea wrote:

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

Thanks Gord, works wonderfull

"Gord Dibben" wrote:

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


On Wed, 14 May 2008 16:40:00 -0700, lea wrote:

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

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

On Thu, 15 May 2008 02:40:02 -0700, lea wrote:

Thanks Gord, works wonderfull

"Gord Dibben" wrote:

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


On Wed, 14 May 2008 16:40:00 -0700, lea wrote:

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