Lists From Another Worksheet

[Reenar]

Hi.

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

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

Thank

 

[Guest]

Hi Reenar,

On Sheet2, add a list box from the "Forms" toolbar. In the "Format
Control>Control" 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]

Thanks a lot.

I saw a posting by dk called one step udated today (posted at
04-30-2006, 05:15 AM) this seems to be what i want to do, but i cant
get the list box / drop down menu to work at it does on DavesExcel's
solution. Any ideas?