Excel 2003 - Linking Cells

[J.Moore]

I want to link a cell which contains a simple math formula to a range of
cells in another worksheet. However, I am unable to "Fill" or "Copy/paste"
without the cell reference changing with those two functions. How can I lock
that cell reference as though it were a constant.

 

[CyberTaz]

Can you be more specific about what you are trying to do? Any one cell can
contain a formula *or* link to another cell but it can't do both. Nor can
one cell link to a range of cells. Your mission isn't very clear.

 

[J.Moore]

One one worksheet I am creating a list of "standards" which the rest of the
spreadsheets will be utilizing. These are derived by math formulas within
the cell and are subject to input in data entry cells.

To "fill out" the other worksheets, I need to include that "standard" as an
element in a math function in a cell within the new worksheet. And, I need
to replicate that
many times within several worksheets and, obviously, manual entry of the
math function/formula into perhaps hundreds of cells is unattractive.

A simple example of the "standard" formula is: =L6*0.1 (named Assumptions!C8)

An example of the receipient cell is: =Assumptions!C8*AssumptionsC4

If I use "Fill" or "Copy" the cell references change for each subsequent
cell copied to.

Does this make it more clear?

 

[Laroche J]

J.Moore wrote on 2009-04-16 13:21:

One one worksheet I am creating a list of "standards" which the rest of the
spreadsheets will be utilizing. These are derived by math formulas within
the cell and are subject to input in data entry cells.

To "fill out" the other worksheets, I need to include that "standard" as an
element in a math function in a cell within the new worksheet. And, I need
to replicate that
many times within several worksheets and, obviously, manual entry of the
math function/formula into perhaps hundreds of cells is unattractive.

A simple example of the "standard" formula is: =L6*0.1 (named Assumptions!C8)

An example of the receipient cell is: =Assumptions!C8*AssumptionsC4

If I use "Fill" or "Copy" the cell references change for each subsequent
cell copied to.

Does this make it more clear?

You're using Excel 2003, which is a Windows version. This is a forum for
Excel on Mac. See
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx to find
out the proper forum, or in a mail or newsreader program filter the
Microsoft News Servers by Excel.

Now for your question. After you enter a cell reference (by typing it or
clicking on a cell) in a formula, press F4 repeatedly and the reference
model will change successively between C8, $C8, C$8, $C$8, (the order may be
different, I don't remember by heart). Read in Help about the difference
between absolute and relative addressing, which will explain the meaning of
the $ sign.

I'd even suggest that those standards cells be given a name, which will make
formulas using them more obvious to understand. For example, you could name
a cell SalesTax, so any formula using it would show SalesTax instead of D45
(or whatever). To define a name, select a cell or a range of cells, click in
the address box of the formula bar, and type the desired name followed by
Enter.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 trial

 

[J.Moore]

That works... Thank you
--
Powderman

J.Moore wrote on 2009-04-16 13:21:


You're using Excel 2003, which is a Windows version. This is a forum for
Excel on Mac. See
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx to find
out the proper forum, or in a mail or newsreader program filter the
Microsoft News Servers by Excel.

Now for your question. After you enter a cell reference (by typing it or
clicking on a cell) in a formula, press F4 repeatedly and the reference
model will change successively between C8, $C8, C$8, $C$8, (the order may be
different, I don't remember by heart). Read in Help about the difference
between absolute and relative addressing, which will explain the meaning of
the $ sign.

I'd even suggest that those standards cells be given a name, which will make
formulas using them more obvious to understand. For example, you could name
a cell SalesTax, so any formula using it would show SalesTax instead of D45
(or whatever). To define a name, select a cell or a range of cells, click in
the address box of the formula bar, and type the desired name followed by
Enter.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 trial