In sheet4 C8 enter =Sheet1!A3


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 15:16:02 -0700, ERICA
wrote:

What is the formula or code I would use if I want to automatically have
information form one worksheet to appear in another worksheet? It should
also automatically update the information also. I am using EXCEL 2003


EXAMPLE: I type CUT in worksheet 1 cell A3 and I want this same info to
show up in worksheet 4 cell C8

Thanks you so much for your help!