E
Ephraim
I would like to know, short of manually sorting and then unsorting, if I could have a worksheet sorted automagically when I have clicked on its tab and then unsorted when I click on any other tab.
The sorted worksheet is called DataEntry and the other worksheet is called WorkOrders. When I click on DataEntry I'd like to have that sheet sorted oncolumn "LastName" and then column "AreaCode". When I click on WorkOrders I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work properly.
I suppose a macro could be written to do this but I am not great with macros.
Thanks
The sorted worksheet is called DataEntry and the other worksheet is called WorkOrders. When I click on DataEntry I'd like to have that sheet sorted oncolumn "LastName" and then column "AreaCode". When I click on WorkOrders I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work properly.
I suppose a macro could be written to do this but I am not great with macros.
Thanks