rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 569
- Office Version
- 365
- Platform
- Windows
I have a block of cells from column A - H that can have a variable number of rows. The data set can also have multiple blocks of data separated by a single blank row. I need to have a macro that will start with row 3 and grab the first block from row 3 to the bottom of the block based on the data in column A, and then sort the data based on the values in Column E. Once that block is sorted, I need it to loop X number of times. I have cell BG1, that displays the number of blocks in the full table. I need the macro to loop through the sort protocol the total number displayed in cell BG1.
All of the cell block have the same number of rows, so if you were to go to cell A3 and use xlEndDown, you would have the total number of rows in each block. You could define that number of rows as a variable and use that in the loop.
I don't know how to write this macro to get through the sorting easily enough.
Please and thank you for any assistance with this.
All of the cell block have the same number of rows, so if you were to go to cell A3 and use xlEndDown, you would have the total number of rows in each block. You could define that number of rows as a variable and use that in the loop.
I don't know how to write this macro to get through the sorting easily enough.
Please and thank you for any assistance with this.