Hi,

I have been trying to work out how I can type text into a cell and have the
same information automatically appear in another part of the same worksheet
and on another worksheet.

In this case I would like address details to be replicated on another
worksheet which is an invoice. The address will appear twice on this sheet.

I've tried everything I can think of and would appreciate some help. I'm
sure I'm missing something very easy...!

Thank you,
Lisa