PC Review


Reply
Thread Tools Rate Thread

Copy Paste Special Transpose Skip Cells and start over

 
 
=?Utf-8?B?bm1w?=
Guest
Posts: n/a
 
      26th Oct 2006
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy from sheet1 then paste special transpose to sheet2,3,4 Christine Microsoft Excel Misc 1 22nd Jul 2009 09:50 PM
Transpose cells - do I use Paste Special? stevewy@hotmail.com Microsoft Excel Programming 10 21st Jul 2009 10:46 AM
how to create a copy/paste special/transpose macro? gerry.lisa@gmail.com Microsoft Excel Misc 6 8th Aug 2007 06:07 AM
Copy formula, paste special value add transpose into another formu =?Utf-8?B?amF5ZWw=?= Microsoft Excel Crashes 0 3rd Aug 2005 07:45 AM
HELP....Is there a way to automate copy/paste special/transpose - =?Utf-8?B?TWVs?= Microsoft Excel Worksheet Functions 7 28th Mar 2005 11:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:12 AM.