Excel How to Autocomplete text/string within a single cell, between different worksheets


Joined
Aug 27, 2017
Messages
1
Reaction score
0
Hi,

I have a huge list of product numbers, for example; 1234567-00-A. I want excel to auto complete the product number when i typed in a single cell.

I have two sheets;
Sheet A has all the lists of unique Product Numbers.
Sheet B has only few records linked with sheet A via vlookup.

Question; when i typed any product number, i have to type complete number.

Is it possible if when i type only first 3 or 4 numbers the complete product number is autocompleted.?


BR///Muhammad
 
Ad

Advertisements

Joined
Aug 8, 2005
Messages
100
Reaction score
15
I have MS Excel 2007 and autocomplete is installed by default. As you have a `huge list of product numbers' I don't think autocomplete will be able to meet your expectations. As far as I know, from my experience, it has limited functionality.
Perhaps someone with more and better experience than me could advise a solution for you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top