Please help me.

[kumawat_s]

presently I link b1 and f1 of "payment" sheet to d1 and e1 of anothe
sheet.

What function should I apply in e1 when I link b1 then in e1 cell th
f1 value should reflect automatically.


_*d1__*_ *_e1_*
b1 of payment next 4th column's value

Please help me.

thanks in advance

skara

 

[starguy]

your question is not clear. what do you mean by link? is it hyperlink o
just =payment!B1. please clarify your question.

 

[kumawat_s]

I want to link just =payment!b1.

your question is not clear. what do you mean by link? is it hyperlink o
just =payment!B1. please clarify your question

 

[starguy]

in cell E1 put following function.
=IF(D1<>"",Payment!F1,"")
this function will return value of cell F1 of Payment sheet if yo
enter value in D1.

hopfully this would be the solution of your problem.