I have a master list of customer names, addresses, postcodes and
financial details with which I want to sort by post code into different
worksheets (to give me approx 25 sublists which will then be linked into
autoroute to show customer location by post code).

I can do this manually but I would like to find a way of setting up the
spreadsheet, so when I import an updated customer list each month it
automatically updates the sublists.

EXAMPLE MASTER LIST

-Postcode Customer name plus other data....-
BN1 Smith Ltd
BN1 Jones and Co
BN1 Brown and Son
BN2 Green Bros
BN2 Pink Inc

EXAMPLE SUBLIST 1 (WORKSHEET BN1)

-Postcode Customer name plus other data....-
BN1 Smith Ltd
BN1 Jones and Co
BN1 Brown and Son

EXAMPLE SUBLIST 2 (WORKSHEET BN2)

-Postcode Customer name plus other data....-
BN2 Green Bros
BN2 Pink Inc

I can put a reference to each postcode I am looking for in cell A1 of
each sublist, and I would like a function that looks for all occurances
of that postcode in the master list and copies all required data into
the sublist.

I have looked at the obvious VLOOKUP and macro options but I cant
figure it out.

Can anyone help???


--
leehutch
------------------------------------------------------------------------
leehutch's Profile: http://www.excelforum.com/member.php...o&userid=26442
View this thread: http://www.excelforum.com/showthread...hreadid=397127