| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data in Designated Cells in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2002: How to tranpose data to designated cells ? | Excel Discussion (Misc queries) | |||
| Excel, function, result to be returned in another designated cell | Excel Worksheet Functions | |||
| Text that includes data from a designated cell? | Excel Discussion (Misc queries) | |||
| When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
Hybrid Mode
