Joined: 20 Mar 2009 Posts: 1 Location: Los Angeles, CA
Posted: Fri Mar 20, 2009 8:16 pm Post subject: Please Help! Moving data in rows to columns
Hello,
I am new to VBA and am in a dilemma. I have several contacts in an excel file where their information is listed in contiguous rows but with two to three lines of space between the start of a new contact. For example the following info is in rows 2 through 7 in column A.
Motion BP CO.
1st Floor,
London UNITED KINGDOM
Tel: 44-207-75509
Fax: 44-20767676
Web: www.111ps.com
and then the following is in rows 11-17 in column A.
745454 INTERNATIONAL
8900 Santa Monica Blvd
Beverly Hills, CA 90212 USA
Tel: 310-310-002
Fax: 310-322-0093
Web: www.260660.com
E-mail: sas@international.com
What I would like to do is get each one of these rows in its own column and then move to the next contact's info and put it underneath the previous.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum