I need to move data from row 2, column A to row 1 column C...Any VBA help would be greatly appreciated.
" - " hyphens are just space markers
Original:
-------Col1---Col2----Col3---Col4
Row1--Dog---Cat---
Row2--Cow---Pig
Row3 (blank)
Row4--Red----Blue
Row5--Grey---Black
Row6 (blank)
*and this keeps repeating to end of document*
I want it to change to:
-------Col1---Col2--Col3--Col4
Row1--Dog----Cat--Cow---Pig
Row2 (blank)
Row3 (blank)
Row4--Red----Blue--Grey--Black
Row5 (blank)
Row6 (blank)
Last edited by steven_e; 09-30-2013 at 12:09 PM.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
that did not work, but I realized I needed space markers to better define the rows and columns. I added hyphens if that helps....this VBA should loop to end of data and do the same for example listed.
So Row 2 Col A & B goes accordingly to Row 1 Col C & D
Last edited by steven_e; 09-30-2013 at 12:18 PM.
can you attach a sample file ?
file attached, thanks
Hi, steven_e,
assuming that there will always be two rows of data and a blank row thereafter:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks