ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Use loop to re-arrange: (https://www.excelbanter.com/excel-programming/397673-use-loop-re-arrange.html)

Ardy

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



All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com