Autocopying text into different cells on the same sheet

**Ciara1977** · 08-13-2009, 11:50 AM

Hi All,
Would really appreciate help with this one please.
I'm trying to set up a document template which prints into 4 pages and would like certain areas and text on page 1 to automatically replicate onto the other pages / ie the text I type into A11 and A12 to J11 and J12 I would like on pages 1, 2 and 5 of the document and any changes to these cells to automatically come up.
So my dilema is twofold! Firstly how to create pages in such a way and secondly how to auto duplicate between cells.
Thanks to anyone who can help!
C.
Edit/Delete Message

**JBeaucaire** · 08-13-2009, 12:56 PM

In Sheet2 and Sheet5, enter this formula in a cell:
=Sheet1!A11

Now, any changes on Sheet1 to cell A11 will show in those cells on those sheets, too.