Copy Paste Special Transpose Skip Cells and start over

N

nmp

I have address data is column C on an Excel spreadsheet. It is formatted
like a normal address in rows within that column and two blank cells between
each address. I need a macro to copy the address-->paste special-->transpose
in a different sheet and then go back and find the next address and do the
same thing. Below are some example of the addresses. They can contain up to
six rows, but some do not have the second street address line.

MACHINERY CORP.
SERVICE MANAGER
555 STATE STREET
P.O.BOX 12345
WAIPAHU, HI 96797
USA


EQUIPMENT CO INC
SERVICE MANAGER
555 W SPRING DR
P O BOX 123
BUTLER WI 53007
USA


EQUIPMENT CO INC
SERVICE MANAGER
55555 WHITE RD

MADISON WI 53716
USA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose cells - do I use Paste Special? 10
Identify row based on criteria and copy paste special values only 4
how to create a copy/paste special/transpose macro? 6
Copy and Paste cells limitation 4
Remove Specific Text - HELP! 6
HELP....Is there a way to automate copy/paste special/transpose - 7
Copy/Paste how to avoid the copy of formula cells w/o calc values 10

Top