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.

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.

Check out your earlier post.

Pete

"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.

The auto correct suggestion wont work. I think I probably wont be able to
figure this one out or I did not explain my self correctly which is probably
the case.

On sheet one I would like to have a list of text pre typed and on sheet 2
staff would enter the text for the code i have created on sheet 1 and fill in
the blank as the information they are documenting will change daily and
weekly. I just want to help them save time typing as basic format for which
they type information does not change but behaviors and responses do.
Thanks again.



"Don Guillett" wrote:


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.

Still unclear. It may be helpful to send your workbook to my address below
along with a clear explanation and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Theresa" wrote in message
...
The auto correct suggestion wont work. I think I probably wont be able to
figure this one out or I did not explain my self correctly which is
probably
the case.

On sheet one I would like to have a list of text pre typed and on sheet 2
staff would enter the text for the code i have created on sheet 1 and fill
in
the blank as the information they are documenting will change daily and
weekly. I just want to help them save time typing as basic format for
which
they type information does not change but behaviors and responses do.
Thanks again.



"Don Guillett" wrote:


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.

I will send it to you. Thanks!

"Don Guillett" wrote:

Still unclear. It may be helpful to send your workbook to my address below
along with a clear explanation and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Theresa" wrote in message
...
The auto correct suggestion wont work. I think I probably wont be able to
figure this one out or I did not explain my self correctly which is
probably
the case.

On sheet one I would like to have a list of text pre typed and on sheet 2
staff would enter the text for the code i have created on sheet 1 and fill
in
the blank as the information they are documenting will change daily and
weekly. I just want to help them save time typing as basic format for
which
they type information does not change but behaviors and responses do.
Thanks again.



"Don Guillett" wrote:


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.