Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference or redirect a formula in a base row?
I am an intermediate Excel end user.
Is there a way to enter a cell formula once, then have other cells in lower rows (but the same column) refer to the "head" cell's formula as if it were in the same row? Sorry this description is so convoluted, but I this is the best I can think of. Let me restate for clarity. I have non-tabular information in rows 1-3. Row 4 contains column labels. Rows 5 and lower contain data (in some columns) and formulas (in other columns). For any given column, I would like to be able to enter the formula once in Row 5. Then enter some other function in Rows 6 and lower which would redirect to the formula in Row 5, except row numbers for relative cell references are updated as if I had done a copy/paster operation. If this function were named referenceFormula(), then cells A5 through A7 would look like this: Cell_ID: Formula As Entered: Actual Formual Behavior: A5 =B5*$A$2+C5 =B5*$A$2+C5 A6 =referenceFormula(5) =B6*$A$2+C6 A7 =referenceFormula(5) =B7*$A$2+C7 The great advantage of this is that I could make a change to a formula in the "base row" and not have to copy/paste or autofill the change back down to all the other rows. Thanks in advance to anyone who responds. - Paul Schrum |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to redirect in VBA? | Excel Discussion (Misc queries) | |||
Changing Cell Reference in a macro on global base | Excel Discussion (Misc queries) | |||
how do redirect | Charts and Charting in Excel | |||
Designating a workbook reference base on a cells contents | Excel Worksheet Functions | |||
redirect from worksheet | Excel Discussion (Misc queries) |