![]() |
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 |
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 |
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 |
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 |
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