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.

--
Regards,

OssieMac


"Perplexed Peter" wrote:

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?