Вопрос:

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

=CELL(speadsheet1!THIS_CELL)

Any ideas?

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

Ответы (1)


0 плюса

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

Решение

In Excel:

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

=INDIRECT("Sheet2!"&CELL("address"))

If it does have a space:

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

Edit: In Google Sheets, try:

=INDIRECT("Sheet2!"&address(row(),column()))
Автор: BruceWayne Размещён: 10.04.2017 02:18
Вопросы из категории :
32x32