software

I want to store a non-worksheet specific formula using cell references in a
lookup table in Excel, so that when the value is looked up, it calculates a
value using the selected formula using the cell references for the sheet that
the lookup command is executed.

Example:

Worksheet 1 looks up a worksheet containing formulas for the formula labled
Form1, which is A1 B2. I want Excel to then use that formula with the
values from the cells A1 and B2 on Worksheet 1. This way, I can have
Worksheet 2 look up the same formula and have it use that formula with the
values of A1 and B2 on Worksheet 2.

The formula worksheet lookup will have multiple formulas (and other data)
repeated across many worksheets, and the worksheets themselves will have to
look up multiple lookup sheets with different sets of formulae (and other
data). As such, I need automation rather than simply copying and pasting
multiple worksheets or lookup tables.

It sounds as though you would be better off creating a number of custom
functions in VBA and saving them all in personal.xls. Custom functions are
worksheet independent, so that =personal.xls!Form1() on any sheet would sum
A1 and B2 on the sheet where entered.

quot;Da' Vanequot; wrote:

gt; I want to store a non-worksheet specific formula using cell references in a
gt; lookup table in Excel, so that when the value is looked up, it calculates a
gt; value using the selected formula using the cell references for the sheet that
gt; the lookup command is executed.
gt;
gt; Example:
gt;
gt; Worksheet 1 looks up a worksheet containing formulas for the formula labled
gt; Form1, which is A1 B2. I want Excel to then use that formula with the
gt; values from the cells A1 and B2 on Worksheet 1. This way, I can have
gt; Worksheet 2 look up the same formula and have it use that formula with the
gt; values of A1 and B2 on Worksheet 2.
gt;
gt; The formula worksheet lookup will have multiple formulas (and other data)
gt; repeated across many worksheets, and the worksheets themselves will have to
gt; look up multiple lookup sheets with different sets of formulae (and other
gt; data). As such, I need automation rather than simply copying and pasting
gt; multiple worksheets or lookup tables.