Auto sort help.

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
 
W

ward376

I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work

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
 
D

Don Guillett

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

To clarify

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top