Hi!

Is it possible?


For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron
Ohio 21657." Now if I begin typing "ABC" in Sheet 2
that data will automaticly appear and I simply
have to hit enter and the data is there


Because one of my friend told me that it is possible But
unfortunately
he also dont know how.


Thanks In Advance


Hardeep Kanwar

I no how to do it ( just did it ) but its har to explain cus im from Denmark
but ill try

select Spell checker menu
select config autocorrector ( i think its the name in english )
in the substitute vindow write ABC
in the with write ABC Computer Supplies, 123 Main Street, Akron
Ohio 21657
ok

hope u got it :-)


"pai" skrev:

Hi!

Is it possible?


For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron
Ohio 21657." Now if I begin typing "ABC" in Sheet 2
that data will automaticly appear and I simply
have to hit enter and the data is there


Because one of my friend told me that it is possible But
unfortunately
he also dont know how.


Thanks In Advance


Hardeep Kanwar

No more possible today than it was May 11th when you first posted this question.

Use a ComboBox as suggested at that time.


Gord Dibben MS Excel MVP

On Sun, 18 May 2008 00:21:51 -0700 (PDT), pai wrote:

Hi!

Is it possible?


For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron
Ohio 21657." Now if I begin typing "ABC" in Sheet 2
that data will automaticly appear and I simply
have to hit enter and the data is there


Because one of my friend told me that it is possible But
unfortunately
he also dont know how.


Thanks In Advance


Hardeep Kanwar