Is there a way to pair up data from consecutive cells in a column? Please see attached. Regards.
Is there a way to pair up data from consecutive cells in a column? Please see attached. Regards.
Hi,
This solution is not pretty but it works.
(non vba)
See attached
You can use this method until you get a more elegant solution.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Hi
try
Please Login or Register to view this content.
rylo
hi Portuga.
Yes it works.
So it is pretty. Thanks.
hi rylo,
though I am novice, I can see the beauty of your code.
never used macros. may I ask some hint from you? (e.g., where to put it)
regards,
This spreadsheet formula, put in C2 and dragged down is another way.
=OFFSET($A$2,(ROWS($A$2:A2)-1)*2,0,1,1) & OFFSET($A$2,(ROWS($A$2:B2)-1)*2+1,0,1,1)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi
When you are in Excel, hold down the alt key and press F8. In the macro name put in something like aaa, then select create. This will open the Visual Basic Editor, and create a module with the start of a code block. Something like
Put the code I gave you into this area, then go back to your spreadsheet, again press alt and F8,select the code and run.Please Login or Register to view this content.
rylo
hi Mike,
It works nicely. It motivates me to learn the "OFFSET" function.
Many thanks.
Hi Rylo,
Today is memorable. My first macro!
It opens doors for me.
Thanks heaps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks