Hello, I need some help. I have 1,700 rows of data with 9 columns of data each.

I need to be able to sort the data in ascending order. I also want excel to keep the sort once saved and closed.

A data example is below:


Row 1: 2789 1003 3456 7867 100 1009 989 2003

Row 2: 7896 2098 7635 99 9897 61 897 4

Row 3.....

As an example column 2 would start with 989 and end in column 8 as 7867.





This goes on for 1700 rows. I have more data coming on Monday that will add another 2000+ rows. The only way I can figure out how to do it is manually. I have no idea how to use macros so if you give me a macro please explain to me how to use it. There is some coding out there for VBA that claims to do what I want it to do, but I have no idea how to insert it or use it. I have figured out how to get into the developer tab.

Thanks in Advance!