Lists From Another Worksheet
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 |
Lists From Another Worksheet
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 |
Lists From Another Worksheet
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: http://www.excelforum.com/member.php...o&userid=34047 View this thread: http://www.excelforum.com/showthread...hreadid=538085 |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com