the autofilter isn't exactly what i'm looking for. does some one have
(or could you create) a macro that toggles between custom views based
on the drop down selection??

On Mar 22, 5:36 pm, Farhad wrote:
Hi,

you can use auto filter.

Thanks,
--
Farhad Hodjat



" wrote:
I have a spreadsheet in which I'd like to be able to sort several
columns at different times (depending on what info I'm interested
in). Is there a way I could get excel to automatically sort the data
based on a selection I make from a drop down?

Example:
A1:A10 are names. B1:B10 are their hours worked. C1:C10 is their
output. D1:D10 is their hourly wage. I'd like a cell (say E1) to be
a drop down with three different options: 'hours worked', 'output',
and 'hourly wage.' Based on which of those three I select, the entire
data set would be sorted based on that criteria.

Can anyone help??

Thanks!

-ADH- Hide quoted text -

- Show quoted text -