Excel Entering Identical Data in a Designated New Cell

[DisMusBeDaPlaz]

To whom it may concern, et al:

As I enter data in a cell, at the same time
I want it to show in another cell.

The information can be either numeric or
alpha-numeric.

Example 1: 302123 entered in Cell "B25", as it is
being typed, will enter into Cell "E44".

Example 2: Beech Ball entered in Cell "D24", will
show in Cell "B48".

Thanks in advance.

Korey

 

[Mike H]

Hi,

Here's how to do it for your first example. Put this in E44

=IF(B25<>"",B25,"")

Mike

 

[Gary''s Student]

In E44 enter:

=IF(B25="","",B25)

 

[Pete_UK]

Put this formula in E44:

=IF(B25="","",B25)

and this in B48:

=IF(D24="","",D24)

and so on.

Hope this helps.

Pete

 

[p45cal]

I doubt very much you'll be able to do it with a worksheet function "a
it is being typed".
There are no key down/key up events for worksheets either, so.
difficult

 

[DisMusBeDaPlaz]

I would like to thank all of you that offered
a helping hand, in the solution to my issue.

Turns out, that the functions & formulas work!

I sincerely thank you all.

Korey


======================