Hi Reenar,

On Sheet2, add a list box from the "Forms" toolbar. In the "Format
ControlControl" menu put the Sheet1 "Destinations" range into the Input
Range and Sheet2!$B$1 into the Cell Link.
That should do it.

Regards,
Eric C.

"Reenar" wrote:


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