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
|