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
--
Message posted from http://www.ExcelForum.com