LinkBack URL
About LinkBacks
I have data in the first column of a sheet:
A
B
C
D
etc.
I now need to create rows with 2 columns where the first row has A B, the second row C D, etc.
It needs to do this until no data is available anymore.
Any pointers? Thanks in advance!
I have data in the first column of a sheet:
A
B
C
D
etc.
I now need to create rows with 2 columns where the first row has A B, the second row C D, etc.
It needs to do this until no data is available anymore.
Any pointers? Thanks in advance!
Use this code -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Alternatively, if you don't want to use macros, you could use the following formula in Cells B1 & C1 (assuming your lists starts in A1):
Cheers, Rob.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks