View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book

I may have misinterpreted but..............

In Sheet2 select A1 and enter =Sheet1!A1


Gord Dibben MS Excel MVP

On 17 Dec 2006 13:26:05 -0800, wrote:

How do I pick up info from a cell from the sheet to the next sheet at
the same location and in th esame workbook?