Thread: Copying Cells from one worksheet to another automaticly
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copying Cells from one worksheet to another automaticly
In any cell on Sheet5 enter =IF(Sheet1!A1="","",Sheet1!A1)

When you change the data in Sheet1!A1, the formula on Sheet5 will return that
value.


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 07:13:00 -0700, loc wrote:

I have a document with 5 worksheets. When I update say worksheet one in a
certain cell, I want it to update worksheet 5 in certain cell. Can this be
done?

Reply With QuoteReply With Quote