Referencing current cell, but from different worksheet

google-sheets cell

70 просмотра

1 ответ

12 Репутация автора

I'm making two spreadsheets in Google Sheets / Excel, where I want to reference the current cell, but in a different spreadsheet.

So I want cell A1 from worksheet 1 to be mirrored in A1 in worksheet 2, B1 from worksheet 1 to be mirrored in B1 in worksheet 2, and so on.

I thought this might work, but it doesn't


Any ideas?

Автор: Kaosmos Источник Размещён: 10.04.2017 02:06

Ответы (1)

0 плюса

18955 Репутация автора


In Excel:

If your other sheet does not have spaces in the name:


If it does have a space:

=INDIRECT("'Sheet 2'!"&CELL("address"))

Edit: In Google Sheets, try:

Автор: BruceWayne Размещён: 10.04.2017 02:18
Вопросы из категории :