C
cagey63
I have a spreadsheet that contains several tabs. On one tab I have
information in two adjacent cells, e.g., A9 and B9. In subsequent
rows this text data may shift over two cells, e.g., c11 and B11. This
pattern may go back and forth; picture an outline format if that is
helpful. I need to copy these staggered cells, two at a time, to the
next tab WITHOUT THE STAGGERED LAYOUT, e.g., all data in columns A:B.
Any ideas on macro code to achieve this?
information in two adjacent cells, e.g., A9 and B9. In subsequent
rows this text data may shift over two cells, e.g., c11 and B11. This
pattern may go back and forth; picture an outline format if that is
helpful. I need to copy these staggered cells, two at a time, to the
next tab WITHOUT THE STAGGERED LAYOUT, e.g., all data in columns A:B.
Any ideas on macro code to achieve this?