Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Data on Row Change
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Data Change after Copy/Paste | Excel Discussion (Misc queries) | |||
Copy Graph But change Data Sheet | Excel Discussion (Misc queries) | |||
Copy data of two cells into one and change formula accordinaly | Excel Discussion (Misc queries) | |||
Select a file, copy it and change some data | Excel Programming |