Thread: How do I link data in 1 cell on 1 worksheet (WS) to another WS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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:


Reply With QuoteReply With Quote