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?

By worksheet, do you mean workbook? The whole excel file is called workbook, and the tabs are actually worksheets. So in your question, I guess you mean 'same workbook' but different 'worksheet'. — Vylix, Aug 08 '19 at 01:21
Assuming we guessed the terminology, it isn't clear what your question is. Are you saying someone inputs a value in some cell, and you want a cell on another tab to show the same value? If so, just stick a reference there to the input cell, as in wrecclesham's answer (you would need to preface it with = to make it a formula instead of just a bunch of text). If you want the second cell to remain blank until there is input in the first cell, you can use IF: =IF(ISBLANK(Sheet2!A1),"",Sheet2!A1). — fixer1234, Aug 08 '19 at 04:20
Related: Display Blank when Referencing Blank Cell in Excel 2010. — G-Man Says 'Reinstate Monica', Aug 09 '19 at 03:21

score 1 · Answer 1 · edited Aug 08 '19 at 01:20

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

edited Aug 08 '19 at 01:20

Giacomo1968

answered Aug 08 '19 at 01:02

Mr Ethernet

1 Answers1