I have data in columns and need a macro to do certain things to the data. Is there a way to make a macro that... here is what I manually do... I put my cursor in the cell where the first of the data begins. I then pull my mouse down to highlight that column's data all the way to the last entry (blank cell below it), then I drag over to the right x-number of columns (which is always the same for each table of data), such that I am selecting the entire table of data. Then I sort on Column A (which is date) and then choose 'oldest to newest.' Then I do some other stuff, but I'll end this post with this 'highlighting/sorting' question.
My spreadsheet consists of numerous tables of data like this and I am always adding more sets of data. Thus, need a macro. Can this be done with a macro? The number of rows varies with each table set (how deep I drag my mouse), that is why I question if it can be done.
My spreadsheet consists of numerous tables of data like this and I am always adding more sets of data. Thus, need a macro. Can this be done with a macro? The number of rows varies with each table set (how deep I drag my mouse), that is why I question if it can be done.
