| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enable auto-expanding lists in a protected worksheet? | Excel Discussion (Misc queries) | |||
| How can you sort a worksheet which has embedded lists? | Excel Worksheet Functions | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Threaded Mode
