ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Entering Identical Data in a Designated New Cell (https://www.excelbanter.com/excel-worksheet-functions/242713-excel-entering-identical-data-designated-new-cell.html)

DisMusBeDaPlaz

Excel Entering Identical Data in a Designated New Cell
 
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

Excel Entering Identical Data in a Designated New Cell
 
Hi,

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

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

Mike

"DisMusBeDaPlaz" wrote:

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


Gary''s Student

Excel Entering Identical Data in a Designated New Cell
 
In E44 enter:

=IF(B25="","",B25)
--
Gary''s Student - gsnu200903


"DisMusBeDaPlaz" wrote:

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


Pete_UK

Excel Entering Identical Data in a Designated New Cell
 
Put this formula in E44:

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

and this in B48:

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

and so on.

Hope this helps.

Pete

On Sep 15, 1:48*pm, "DisMusBeDaPlaz" wrote:
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



DisMusBeDaPlaz

Excel Entering Identical Data in a Designated New Cell
 
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


======================
"Mike H" wrote in message
...
Hi,

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

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

Mike

"DisMusBeDaPlaz" wrote:

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




All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com