ExcelBanter - how to auto copy the value of B3 to E5?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how to auto copy the value of B3 to E5? (https://www.excelbanter.com/new-users-excel/97375-how-auto-copy-value-b3-e5.html)

chart maker

how to auto copy the value of B3 to E5?

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

Dave Peterson

how to auto copy the value of B3 to E5?

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

All times are GMT +1. The time now is 08:35 AM.