please help me link cells that have numbers and letters

T

thuma1004

Can anyone help me learn how I can type a stock number on sheet 1 in m
workbook that contains both letters and numbers and have i
automatically show up in a dedicated cell on sheet 2. I can do thi
with numbers only, but I heard it can be done. Any help on this matte
is greatly appriciated
 
F

Frank Kabel

Hi
not really sure what you're trying to do. What formula do you use for
numeric values?
 
G

Gord Dibben

In dedicated cell on sheet2 enter =Sheet1!A1

Whatever you type or enter in Sheet1A1 will be returned in Sheet2

Or are you looking for something else?

Gord Dibben Excel MVP
 
Top