| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting one data entry into another
i have a workbook containing 3 sheets sheet one is my main one the other two
are for reference , on sheet two i have a data entry of "2N" in cell C76. i want to shoe this data entry on to my main sheet in exactly the same cell location C76, but i want the entry to say "S" instead of "2N". at the moment i have managed to get the Cells to link up using the 3D function it's the conversion i have trouble with? can any body give me some idea or direction. cheers -- fury ferret |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting one data entry into another
In Main sheet C76 enter
=IF(Sheet2!C76="2N","S","") Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 15:02:01 -0800, Dave wrote: i have a workbook containing 3 sheets sheet one is my main one the other two are for reference , on sheet two i have a data entry of "2N" in cell C76. i want to shoe this data entry on to my main sheet in exactly the same cell location C76, but i want the entry to say "S" instead of "2N". at the moment i have managed to get the Cells to link up using the 3D function it's the conversion i have trouble with? can any body give me some idea or direction. cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting continuous data into binary data | Excel Worksheet Functions | |||
| Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| How do I stop Excel from converting a numerical entry to a date? | Excel Discussion (Misc queries) | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
Linear Mode
