Re: Re: how to rearrange the months in non alphabetical order??
thanks it worked,but the ranks are shown ,how do I get the month names.
eg: if you see sheet 5 in my file attached file how do I pull the rearranged names?? like in my list box delivery details I want the months to be present in the Jan to Dec order... how to do it??Please help.
Re: how to rearrange the months in non alphabetical order??
Ouch!!! It hurts to see that so many people suggest an inline table to solve this problem...
An inline table will work, but it is a clumsy method. It is much better to interpret the month name so that it gets a dual format that automatically gets sorted correctly . Here's how you should do it:
First, make sure that you have the environment variables in the beginning of the script: