Please help me.

[kumawat_s]

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

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


d1 e1
b1 of payment next 4th column's value

Please help me.

thanks in advance

skaran

[starguy]

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

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

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


d1 e1
b1 of payment next 4th column's value

Please help me.

thanks in advance

skaran

[kumawat_s]

I want to link just =payment!b1.

your question is not clear. what do you mean by link? is it hyperlink or 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 you enter value in D1.

hopfully this would be the solution of your problem.

I want to link just =payment!b1.