Please help me.

K

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
 
S

starguy

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

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.
 
Top