Hello Max,

Thank you for the reply.

But I am new to the Excel so where and how do you put those formula?

Please let me know..

Oh and Cell K4 and Cell N4 it could have "W" or "L"

So if I put W it will shows W on other Cell and if I put L then it will
shows L

Thank you...

"Max" wrote:

Perhaps this might suffice ..
In O9: =IF(K4<"W","",K4)
In O10: =IF(N4<"L","",N4)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Astroboy" wrote:
Hi everyone..

This is what I am looking for..

When I enter "W" on Cell K4 and then "W" will automatically enter on Cell O9

When I enter "L" on Cell N4 and then "L" will automatically enter on Cell O10

etc... etc...

Is it possible to do that???

Please let me know and thank you~~~~