Take a look at this link and see if it could work for you. It uses
filter copy on unique records and should accomplish what you need with
some mods.
http://groups.google.com/group/micro...ae224707a3ac85
(E-Mail Removed) wrote:
> I have large list of business addresses (see below). There are
> multiple rows for each company (varies). I would like to sort down the
> list by company name (column 1) and for each new company i would like
> to copy the line and paste it in a different worksheet (so that i will
> have a list with one row for each company).
>
> Current Data:
>
> ZIPSORT INC 100042011 1820 WRIGHT ST
> ZIPSORT INC 100044694 4950 S 6TH ST
> ZIPSORT INC 100044694 4950 S 6TH ST
> ZIPSORT INC 100044694 4950 S 6TH ST
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZANDER PRESS INC 49060600 425 W RYAN ST
> ZANDER PRESS INC 49060600 425 W RYAN ST
> ZANDER PRESS INC 49060600 425 W RYAN ST
> XL MARKETING GROUP INC 10004165 845 BONNIE LN
> XL MARKETING GROUP INC 10004165 845 BONNIE LN
> XL MARKETING GROUP INC 10004165 845 BONNIE LN
>
> Goal:
> ZIPSORT INC 100042011 1820 WRIGHT ST
> ZIP MAIL SERVICES 10008799 4350 UNITED PKWY
> ZANDER PRESS INC 49060600 425 W RYAN ST
> XL MARKETING GROUP INC 10004165 845 BONNIE LN
>
> What are some basic functions to do this?
Similar Threads
