ExcelBanter - How do I link data in 1 cell on 1 worksheet (WS) to another WS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I link data in 1 cell on 1 worksheet (WS) to another WS (https://www.excelbanter.com/excel-worksheet-functions/225053-how-do-i-link-data-1-cell-1-worksheet-ws-another-ws.html)

Frankl632dw

How do I link data in 1 cell on 1 worksheet (WS) to another WS

Gord Dibben

How do I link data in 1 cell on 1 worksheet (WS) to another WS

=Sheet1!A1 entered in any cell on Sheet2

Alternate route...................

Type an = sign in a cell on Sheet2 but don't hit ENTER key just yet.

Switch to Sheet1, select a cell and hit the ENTER key.

Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 15:00:02 -0700, Frankl632dw
wrote:

All times are GMT +1. The time now is 09:41 PM.