Hi.

I have a workbook with two sheets. On sheet 1 - Coloum A has
destinations and Coloum B rates for these destinations.

On Sheet two I would like to be able to create a list for the data on
Sheet 1 On Sheet Two in Coloum A1, I would like a destination list
(auto filter type with drop down list) and when a destination is picked
(data from Coloum A Sheet 1), the rate also comes through in Sheet 2
B1.

Thanks


--
Reenar
------------------------------------------------------------------------
Reenar's Profile: http://www.excelforum.com/member.php...o&userid=34047
View this thread: http://www.excelforum.com/showthread...hreadid=538085