Number Placing

[Russ]

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.

 

[joeu2004]

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.

 

[Guest]

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

VLOOKUP is a likely candidate.

 

[Russ]

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

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.