I am using a table to select a value. Either 1,2,3,4,5,6,7,8,9,10.
Then based upon what value is how I would sort 7000 lines (rows) of data. There are 5-6 columns. I have a macro that I can use to sort depending on which value but I was hoping that It would do it automatically.
Like if I had selected 3 then it would sort first on column C.
Right now I can manually select a macro that I have but to do this automatically would be great.
I have a huge list that It would be easier to find an item if I first sorted based upon a criteria.
Something like: If C=1 then run macro 1, If C=2 then run macro 2, etc...
Thanks - I have came along way so far. Thought to automate would be nice.
Bookmarks