"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