Searching a text and filling a cell with the result

  • Thread starter Thread starter pauloterra
  • Start date Start date
P

pauloterra

Hi everybody!

This is my first visit on this forum! And my first question too!

I have a Worksheet that contains a long list of street names.

I have another Worksheet which I use to fill in with the names of th
streets of the Worksheet above.

In the cell that I fill the name of the street, I would like to open a
window where I can search, find and select the street that I want, and
as I choose the street name, it is automaticly filled up on the cell
opened this window.

I think that the only way I have to do this is by a macro. But I don´
know how to proceed to do this.

If someone can help me, I would be so glad.

Sorry for my english.

Thanks in advance.

Paulo Terr

Attachment filename: street sheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40751
 
Hi Paulo,

I believe there is built in functionality within Excel to match you
needs already!

It is called Validation, and can be referenced through the menu bar.
Select the cell(s) you want the list to appear in and navigate throug
the menu bar via / data / validation.

Select 'List' from the list box and set the range to be the data rang
that contains the street names.

If the range is on another sheet (as is your case), you'll need to nam
the range beforehand and type '=Whatever_the_range_name' in the Sourc
box because for some reason you cannot cross sheets from this rang
selector.

I'm not sure what version of excel this was introduced on, but I'
using 2002 and it was on 2000 also I believe.


Regards,

Boicie

Attachment filename: xl_forum street sheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40760
 
Hi Boicie,

Thank you for your reply but i´m afraid it doesn´t solve my problem.

I need an interface where i can search for the name of the street
becose there are about 10000 streets and its not easy to find a street
on this list.

I need something like a screen where i can type part or the entire name
of the street and it shows me a small list where i can click on the one
i want and its name goes to the cell.

But, anyway, i´m glad for your help.

Paulo
 
Back
Top