How do I create a macro that will copy 500 rows of data in the range
A2:AC501 within sheet "Box500" and paste into sheet "BoxSort", then
sort the 250 even rows together (2, 4, 6,....498, 500), followed by
the 250 odd rows together (3, 5, 7,....497, 499) and copy and paste
the header row on row 1.
A2:AC501 within sheet "Box500" and paste into sheet "BoxSort", then
sort the 250 even rows together (2, 4, 6,....498, 500), followed by
the 250 odd rows together (3, 5, 7,....497, 499) and copy and paste
the header row on row 1.