importing multiple values from a spreadsheet

[Perplexed Peter]

Hi, I am trying to workout how to import multiple values from a ssheet into
another sheet. I am using postcode to import all suburbs matching the
postcode into another table. The sheet i am importing from has multiple
rows, 1per suburb with postcode and suburb in each row?

 

[OssieMac]

I wonder how many you are trying to copy to the other worksheet. If not an
excessive number, try using Autofilter. (Get more info on this from help).
You can then set a filter to the required postcode and only the suburbs
pertaining to that postcode will be displayed. You should then be able to
select and copy and paste them.

 

[Perplexed Peter]

thanks mate - i am needing to potentially copy the suburbs for a number of
postcodes and I was hoping to have it automatically populate when the
postcodes are entered. Each Postcode will have up to 5 suburbs.