importing multiple values from a spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Perplexed Peter - 28 May 2008 02:29 GMT

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?

Reply to this Message

OssieMac - 28 May 2008 07:41 GMT

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.

Signature

Regards,

OssieMac

> 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?

Reply to this Message

Perplexed Peter - 29 May 2008 00:05 GMT

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.

> 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).
[quoted text clipped - 6 lines]
> > postcode into another table. The sheet i am importing from has multiple
> > rows, 1per suburb with postcode and suburb in each row?

Reply to this Message