hello,

perhaps you can help me with this:

in column A i have different values, for example:
A B
1 aa
2 bb
3 cc

in column B i want to define cells as reference to some named cells located
elsewhere. for example: cell B1: =aatotal and so on in other cells:
bbtotal, cctotal...
how can i define formulas in B column based on values in A in order not to
retype aa bb cc in all the cells. something like B1: =A1total ... ?

thanks,

Alex.

"R.VENKATARAMAN" wrote:

if use absolute addresses the address will not chane. for e.g. $C$35 will
remain as c35.

another function <indirect also will be usefu. see help

use some such method of using cell addresses instead of names of ranges.

====================
Steve L <Steve wrote in message
...
I have a spreadsheet I am using for financial statements. In one area, I
have
to create sub-totals based on the rows above.

The problem is that some of the cells are set up as named ranges for use
elsewhere, and some are not. As a result, the formulas for my sub-totals
contain both names and cell references. When I try to copy these formulas
to
adjacent cells for other months, some formula components change (eg. C35
becomes D35) while others don't (eg. Jan_Sales stays as Jan_Sales).

This makes a complicated edit, overly prone to errors. It is also not
something I am comfortable turning over to someone else to use on an
ongoing
basis.

I could create names for the un-named cells, but this would result in a
HUGE
number of names to set up. Is there any way to use the cell reference for
the
named cells in the formulas I am creating?