How do I populate an Excel 2010 cell when a different cell is manually populated the same worksheet but a different tab?

Question

How do I auto populate an Excel 2010 cell when a different cell is manually populated in the same worksheet but a different tab?

Answer 1

To reference a single cell in another tab:

Sheet_name!Cell_address

E.g.

Sheet2!A1

To reference a range of cells in another tab:

Sheet_name!First_cell:Last_cell

E.g.

Sheet2!A1:B2