Hello-- I have about 2000 rows with values in individual cells. I enter the values in each day, in numerical order, smallest to largest. While taking time off the person doing this for me didn't bother to sort the rows correctly and now they're a mess. I'd like to loop through each row, sort them properly, then move to the next row. I'r really like to use a macro so I'm not sitting here for a week.
My data range starts at (E2:I2) and runs for +/- 2000 rows, always (En:In). I'd like the loop to run until it hits an empty cell in the next row.
Thanks in advance.
My data range starts at (E2:I2) and runs for +/- 2000 rows, always (En:In). I'd like the loop to run until it hits an empty cell in the next row.
Thanks in advance.