I need to create an absolute reference in a calculated column so that when I
copy the formula across to subsequent columns the formula continues to refer
to the equivalent of $D4. How is this done using table columns? When I copy
now to the next column it applies a relative reference.

Can you be more specific? $D4 will always refer to Column D, but the
row will remain relative. $D$4 will always refer to D4.

$D4 is a combination of an absolute column address ($D) and a relative row
address(4). If you want to reference D4 always, use $D$4.

Tyro

"Humphrey" wrote in message
...
I need to create an absolute reference in a calculated column so that when
I
copy the formula across to subsequent columns the formula continues to
refer
to the equivalent of $D4. How is this done using table columns? When I
copy
now to the next column it applies a relative reference.

What I was after was an absolute reference using the table nomenclature ie,
Table_CBCC_Data[[#This Row],[dateBudget]]. Is there a table formula
equivalent in 2007 to $D4, something like Table_CBCC_Data[[#This
Row],$[dateBudget]].

"Humphrey" wrote:

I need to create an absolute reference in a calculated column so that when I
copy the formula across to subsequent columns the formula continues to refer
to the equivalent of $D4. How is this done using table columns? When I copy
now to the next column it applies a relative reference.

On 14 jan, 22:19, Humphrey wrote:
What I was after was an absolute reference using the table nomenclature ie,
Table_CBCC_Data[[#This Row],[dateBudget]]. *Is there a table formula
equivalent in 2007 to $D4, something like Table_CBCC_Data[[#This
Row],$[dateBudget]]. *



"Humphrey" wrote:
I need to create an absolute reference in a calculated column so that when I
copy the formula across to subsequent columns the formula continues to refer
to the equivalent of $D4. *How is this done using table columns? *When I copy
now to the next column it applies a relative reference.- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Humprey,

I've got the same problem and no direct answers. The simple $ trick
still works but is not what we want.
Im using 12 colomns with for the monthly turnover calculations
(sumproducts) and some colomns with input for this calculations. The
input colomns need an absolute reference in the sumproduct. Using the
new tableformat i can't copy one month over all twelve. I have to
manualy correct the formula or loose the new tabel functionality and
use the old $ trick.

For now I've a small issue (12 corrections is overseeable) but i have
to do the same exercise over 52 weeks and next all working days later
on.....

I hope adding the same problem in different words will help.

Humphrey,

Just got the answer myself in a newer post. Use indirect to make it
absolute
so i.e Table_CBCC_Data[[#This Row],[dateBudget]] becomes
INDIRECT("Table_CBCC_Data[[#This Row],[dateBudget]]")
this will be absolute

see also http://www.cpearson.com/excel/indirect.htm


On 14 jan, 22:00, Humphrey wrote:
I need to create an absolute reference in a calculated column so that when I
copy the formula across to subsequent columns the formula continues to refer
to the equivalent of $D4. How is this done using table columns? When I copy
now to the next column it applies a relative reference.