I have a workbook that has lists in two seperate sections of columns (a-q and s-aa) and that can be sorted via different macros to list different amounts in each column. I want to hide all results that are sorted that end up at the bottom of the list after the sort. When it sorts, all applicable info is listed at the top set of rows, there are 0's in between (hidden to look blank), and then whatever didn't hit the top of the list is sorted to the bottom.
I have a cell that lists which is the last row that contains usable info based on the sort at AI4.
How do I set up a macro to hide all rows after whatever row number shows up at the AI4?
At the end of the day I want to add this to each of the macros that are used to sort the lists, so it automatically only shows relevant data.
Thank you for any help.