Formula??? to automatically have the same text copied

**Hester** · 12-22-2011, 08:10 AM

I am trying to learn excel and would like to knw if it is possible to automatically have the same text copied to s specific cell in another sheet? And if it is entered in one worksheet have it automatically changed in the other sheet's cell that is linked to it. It that possible and if yes, could you please advice on how to do it? Thank you

**dilipandey** · 12-22-2011, 08:16 AM

Hi Hester,

Linking (copy - pastespecial- paste link) could be one solution for this, but yes the other sheets need to be refreshed (update links) when opened.

Regards,
DILIPandey

<click on below 'star' if this helps>