Put a complete list in another worksheet and use data|validation on the input
cells. Then you can use the dropdown arrow to select the name you want.

Type in a unique code for each company. When you're done, select the range and
do a bunch of Edit|Replaces.

Use Autocorrect. Create those same kind of codes under
Tools|Autocorrect Options|Autocorrect tab
that converts your code to the company name you want.



TQ wrote:

Hi,

I got certain data keep repeat in the same worksheet, I have to rekey
everytime.I have notice that some data will auto appear the whole line after
I key in the first few alphabets,but some is not.For those not auto appear
data, actually I already key in for few times, any solution,or any other
better way to improve when keep typing the same data ?

Those data I keep retype format as below,

space - space ABCDEFG Co.
space - space TAGADFFA Co.

Thanks.

--

Dave Peterson