Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Beginner - Excel - Auto look up values from worksheet 3 from User
Hi again,
I would greatly appreciate any advice on how to achieve the following: 1. I have an Excel template that has all Australian Postcode infro stored in "Sheet3" 2. This template also has a UserForm "frmParent" that asks for user input. 3. When all user input is completed, it will be stored in "Sheet1" 4. 2 of the fields asked for are "txtParentSuburb" and "txtParentPostcode" 5. I would like to be able to dynamically lookup in "Sheet3" either: 5a. The correct Postcode for an entered Suburb, ot 5b. The correct Suburb name for an entered Postcode 5c. And then transfer the correct info back to the UserForm I guess my biggest problem lies in the fact that each Suburb can have multiple Postcodes, due to the sub-area distribution of Austraila Post delivery areas . Any ideas or advice is greatly appreciated Kind regards duBe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Beginner in excel | Excel Discussion (Misc queries) | |||
Excel Beginner, | Excel Worksheet Functions | |||
Auto log off a user with a worksheet open? | Excel Discussion (Misc queries) | |||
EXCEL-Beginner | Links and Linking in Excel | |||
A beginner needs help with Excel and VB | Excel Programming |