About Us

Theresa

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need help w/ formula not very excel smart	Theresa	Excel Worksheet Functions	2	February 13th 09 02:01 AM
Cannot get the smart tags to work in Excel	[email protected]	Excel Worksheet Functions	0	September 25th 08 01:22 AM
Smart Art graphics in Excel 2007	Charles Eaves	New Users to Excel	0	September 4th 08 04:48 PM
Smart calculations with Excel?	Christian	Excel Worksheet Functions	3	October 15th 07 04:38 AM
smart tags in Excel?	Jr Geek Squad Wanna Be	Excel Discussion (Misc queries)	0	September 21st 05 10:13 PM

Menu

About Us