How to search and copy cell content to another sheet?
Hi,
Let's say you have one sheet with a list of products.
Column1 = product name
Column2 = product number
I would like to have a cell on Sheet2, where I can start typing something,
and it would let me see a list based on what I typed so far.
E.g when I type "Volks" it should show a list of all Volkswagen Cars.
If I then choose the value, it should use this value and add the product
number in the cell next to it.
What function should I use, or how can I do this?
Thanks,
Roel
|