I need help creating a macro that sorts the data in sheet#2 at cell B1 as
Descending "from Z to A" when I click on Save.
normally, I only click save when I'm done with the file, so it doesn't
matter if the macro activates only if I click save, but something similar
also works.
because sorted data doesn't update when the values change for what ever
reason, I have to click on Sort Descending each time I update the data. and I
want to automate it using a macro.
I have posted earlier a question "why Sort Descending does not refresh?" and
I got an answer that I can do that using a macro, but I don't have skill in
VB to do it myself. please assist.