You could do this with a worksheet_change event looking up the text. Show us
the layout of the text tables.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Theresa" wrote in message
...
Hello
I would like to type a code into a cell that would then paste text from
another sheet.
Is this possible if so what is the formula.

Example: I would like to enter this code ARTW1G1
and then the text entered into that cell would be
Joe attended ART lead by Jane (RCC). The learned the SLT skill Helping
others.

Does what i am asking make sense. Thank you.