copy cell data to other worksheet cell, leave blank if no not currently filled

[Tomkat]

Hi,

I am wanting to have certain cells of data from one worksheet appear on another worksheet once the cells on the first sheet have data entered in them.

I find that I can do a simple formula to copy the cell but I want the cell to remain blank until data is added in the first sheet (it will be a mix of text and numerical entries).

If anyone is able to help me with this it would be greatly appreciated

 

[hippiehacker]

basically a formula to get A1 from Sheet1 would be

=IF(Sheet1!A1="";"";Sheet1!A1

)

 

[User1981]

You can just use a linked cell.
Then, however, if the source cell is blank, the linked cell will show a "0" value.
so you just wrap an IF formula around the link.

It won't let the linked cell content truly blank, but it appears blank ("").

This example links the cell A1 on Sheet1. copy it to your desired destination.

=IF(Sheet1!$A$1="","",Sheet1!$A$1)

edit: hippihacker was faster, posted while I was still writing

 

[hippiehacker]

yeah and I see i was faster but forgot to change the ; to , in my formula

 

[Tomkat]

yeah and I see i was faster but forgot to change the ; to , in my formula

That does the trick, thank you both!!