copying "staggered" outline data from one tab to another, lining up the data on the target tab

  • Thread starter Thread starter cagey63
  • Start date Start date
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?
 
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?
Click to expand...

?
 
Back
Top