Multiple cell autocomplete

[arthursdomain]

Anyone know if its possible to have multiple cells autocomplete like a
single cell would if you were to type the same word or phrase in the
cell. If it could work over mutliple cells by typing in a letter for
example:

COL1 COL2 COL3 COL4
CAT IN THE HAT

If i just typed in "C" in COL1 that COL2, COL3, COL4 Would autocomplete
and type in IN THE HAT

Using M$ Excel 2002
on Windows 2000 Pro

Thanks!
Z

 

[Ken Wright]

With all the cells in question selected, type as normal and when your
autocomplete gives you the word you are looking for, hit CTRL+ENTER and it
will enter that data in all the selected cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[arthursdomain]

I tried and I got the following results
I highlighted column 1-4 and Typed in C
and col1-4 had CAT in the cell. Im looking if that If i type C
In col1 col2 will then automatically fill with IN
col3 will fill with THE col4 will fill with HAT
Which is what i typed in the previous row
COL1 COL2 COL3 COL4
CAT IN THE HAT
(so the next row i type "C")
Cat in the hat
(at in the hat gets filled in for me in col2, 3, and 4)

Another example is like:
COL1 (employees name)
COL2 (employees number)
COL3 (employees age)

So when I type the employees name in the first col. It will also fill
col 2 and 3 with the approriate information. kinda like a database,
but just with previously entered items.

Z

 

[Ken Wright]

Aaaahhh, sorry just twigged. Take a look at the VLOOKUP function, but it
requires you to have a table of values to pull from. This will not work
with any kind of autocomplete. It can however be combined with data
Validation in the first cell, such that you choose the first cells value
from a dropdown list and the rest automatically fills in.

Regards
Ken.............................

 

[swatsp0p]

wouldn't a vlookup work for you? Have a 'database' on another shee
with employee's names, numbers, etc. and then just enter data in on
cell and let vlookup fill in the remainder of the cells.

Bruc

 

[arthursdomain]

So what youre saying is that this is only possible with a
pre-determined set of values, so I would need to first input every
employees name into a table... then it could be used to recall the rest
of the data?

Z

 

[Ken Wright]

If I read your requirements correctly, yes.

Regards
Ken...................

 

[arthursdomain]

Okay - Much thanks!

Z