Linking cells...easy one
 

Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when
there is nothing entered in cell A1, D5 is blank, mine show up as 0??

"FSt1" wrote:

hi,
you can use a formula.
if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell
d5, then in D5 put the formula =sheet1!A1.
what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5.
NO macro needed.

Regards
FSt1

Linking cells...easy one
 

You could use an IF statement.

=IF(A1="","",A1)

So, if A1 is blank, then return blank, else return value of A1.

HTH,
Elkar


"SLKoelker" wrote:

Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when
there is nothing entered in cell A1, D5 is blank, mine show up as 0??

"FSt1" wrote:

hi,
you can use a formula.
if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell
d5, then in D5 put the formula =sheet1!A1.
what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5.
NO macro needed.

Regards
FSt1

Linking cells...easy one
 

THANK YOU........ It worked perfectly.

Thanks so much Elkar!

"Elkar" wrote:

You could use an IF statement.

=IF(A1="","",A1)

So, if A1 is blank, then return blank, else return value of A1.

HTH,
Elkar


"SLKoelker" wrote:

Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when
there is nothing entered in cell A1, D5 is blank, mine show up as 0??

"FSt1" wrote:

hi,
you can use a formula.
if you had data in sheet 1 cell A1 and you want this shown in sheet 2 cell
d5, then in D5 put the formula =sheet1!A1.
what ever is in sheet 1 cell A1 will also show in Sheet 2 cell D5.
NO macro needed.

Regards
FSt1