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

If you are always going to insert the address in the same cell, say D6 in
Sheet1, then where you want the addresses to appear in Sheet2, enter the
following formula: =IF(Sheet1!D6="","",Sheet1!D6)

"Lisa" wrote:

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

"Kassie" wrote in message
...
If you are always going to insert the address in the same cell, say D6 in
Sheet1, then where you want the addresses to appear in Sheet2, enter the
following formula: =IF(Sheet1!D6="","",Sheet1!D6)

Thank you Kassie - that worked a treat!

Lisa

My Pleasure and privilege. Thanks for the response

"Lisa" wrote:

"Kassie" wrote in message
...
If you are always going to insert the address in the same cell, say D6 in
Sheet1, then where you want the addresses to appear in Sheet2, enter the
following formula: =IF(Sheet1!D6="","",Sheet1!D6)

Thank you Kassie - that worked a treat!

Lisa