Number Placing

  • Thread starter Thread starter Russ
  • Start date Start date
R

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.
 
Russ said:
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?
Click to expand...

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.
 
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.
Click to expand...
 
Back
Top