How about just make E5 retrieve the value from B3?

=B3

or better if B3 could be empty:

=if(b3="","",b3)



chart maker wrote:

how to automaticaly copy the value of B3 to E5 while inputing value in B3?

--

Dave Peterson