software

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: www.excelforum.com/member.php...oamp;userid=34047
View this thread: www.excelforum.com/showthread...hreadid=538085Hi Reenar,

On Sheet2, add a list box from the quot;Formsquot; toolbar. In the quot;Format
Controlgt;Controlquot; menu put the Sheet1 quot;Destinationsquot; range into the Input
Range and Sheet2!$B$1 into the Cell Link.
That should do it.

Regards,
Eric C.

quot;Reenarquot; wrote:

gt;
gt; Hi.
gt;
gt; I have a workbook with two sheets. On sheet 1 - Coloum A has
gt; destinations and Coloum B rates for these destinations.
gt;
gt; On Sheet two I would like to be able to create a list for the data on
gt; Sheet 1 On Sheet Two in Coloum A1, I would like a destination list
gt; (auto filter type with drop down list) and when a destination is picked
gt; (data from Coloum A Sheet 1), the rate also comes through in Sheet 2
gt; B1.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Reenar
gt; ------------------------------------------------------------------------
gt; Reenar's Profile: www.excelforum.com/member.php...oamp;userid=34047
gt; View this thread: www.excelforum.com/showthread...hreadid=538085
gt;
gt;


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?--
Reenar
------------------------------------------------------------------------
Reenar's Profile: www.excelforum.com/member.php...oamp;userid=34047
View this thread: www.excelforum.com/showthread...hreadid=538085