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!

In sheet4 C8 enter =Sheet1!A3


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 15:16:02 -0700, ERICA <(E-Mail Removed)>
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!