Copy Data on Row Change

[paul.klinker]

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?

 

[acampbell012]

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/micr...k=gst&q=acampbell012&rnum=12#cbae224707a3ac85