I have columns of data that goes through A:I. Is there a macro to create new columns? It is kind of hard to explain what I want to do, but I'll try. I have columns of data. In column A, I have numbers that start going up. If the number in the column A row n+1 is greater than n, id like to take all the data below that point and put it in K:S (leaving a blank column). Then perform same operation on column K. Note that data in the columns next to the column being sampled needs to move with that column.
I doubt this makes sense, but worth a shot to ask.
Bookmarks