View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ardy Ardy is offline
external usenet poster
 
Posts: 136
Default Use loop to re-arrange:

Hello All:
I really am getting stock on this. Can somebody start me and I try to
fine tune it. I have two column ("A:B") worth of survey points. Each
5 row (1,2,3,4,5) makes a cross section, I need start with row 2 -
"2A" and "2B" and move it to "1C" and "1D " then "3A" and "3B" move it
to "1E" and "1F" then "4A" and "4B" move it to "1G" and "1H" then "5A"
and "5B" move it to "1I" and "1J".

This completes one set of data that will give one cross section. I
need to do this loop until it hits an empty cell.

Thanks