Auto sort help.

  • Thread starter Thread starter Ephraim
  • Start date Start date
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
 
I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work
Click to expand...

Do you want this data sorted because you want vlookup to find
particular values first?

If you want vlookup to find exact matches regardless of the way the
data is sorted, make the last argument (Range_Lookup) "False".

Thanks!
Cliff Edwards
 
Do you want this data sorted because you want vlookup to find
particular values first?

If you want vlookup to find exact matches regardless of the way the
data is sorted, make the last argument (Range_Lookup) "False".

Thanks!
Cliff Edwards
Click to expand...

To clarify

=vlookup(value,range,2,false) or
=vlookup(value,range,2,0) that's a zero
 
Back
Top