I have a worksheet with many excel spreadsheets in them. This is what I want
to do. I am looking for a formula that will move a number from one
spreadsheet to another. For example, I have spreadsheets A, B, C & D.
Numbers that I need in spreadsheet A are in B & C. What formula can I use to
accomplish my goal? Thank you.

Russ wrote:
I have a worksheet with many excel spreadsheets in them. This is what I want
to do. I am looking for a formula that will move a number from one
spreadsheet to another. For example, I have spreadsheets A, B, C & D.
Numbers that I need in spreadsheet A are in B & C. What formula can I use to
accomplish my goal?

You cannot "move" numbers with a formula, at least not in the literal
sense. Instead, you can __refer_to__ (reference) cells. You
accomplish this the same way whether the referenced cells are in the
same sheet or in another sheet of the same workbook. The syntax for
off-sheet references is something like SheetB!C2. But arguably the
easiest way to reference a cell, be it in the same sheet or in a
different sheet, is simply to move the cursor to that cell while you
are writing a formula. For example, in cell A1 on Sheet A, type "=",
then click on the Sheet B tab at the bottom of the window, move to cell
C2 in Sheet B, then press Enter. That creates the formula =SheetB!C2.
Of course, you can create cell references in much more complex formulas
as well. That merely demonstrates the basic mechanics.

Russ,
Can you give an example? What relationship exists to determine
the numbers to be moved?

VLOOKUP is a likely candidate.

"Russ" wrote:

I have a worksheet with many excel spreadsheets in them. This is what I want
to do. I am looking for a formula that will move a number from one
spreadsheet to another. For example, I have spreadsheets A, B, C & D.
Numbers that I need in spreadsheet A are in B & C. What formula can I use to
accomplish my goal? Thank you.

I think that did the trick. Thank you very much.

wrote in message
ps.com...
Russ wrote:
I have a worksheet with many excel spreadsheets in them. This is what I
want
to do. I am looking for a formula that will move a number from one
spreadsheet to another. For example, I have spreadsheets A, B, C & D.
Numbers that I need in spreadsheet A are in B & C. What formula can I use
to
accomplish my goal?

You cannot "move" numbers with a formula, at least not in the literal
sense. Instead, you can __refer_to__ (reference) cells. You
accomplish this the same way whether the referenced cells are in the
same sheet or in another sheet of the same workbook. The syntax for
off-sheet references is something like SheetB!C2. But arguably the
easiest way to reference a cell, be it in the same sheet or in a
different sheet, is simply to move the cursor to that cell while you
are writing a formula. For example, in cell A1 on Sheet A, type "=",
then click on the Sheet B tab at the bottom of the window, move to cell
C2 in Sheet B, then press Enter. That creates the formula =SheetB!C2.
Of course, you can create cell references in much more complex formulas
as well. That merely demonstrates the basic mechanics.