What I want to do is below. It might be most easily done through a Pivot Table, but that was why I wanted to ask. I have not used Pivot Tables in 6-7 years.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
EXAMPLE WORKSHEET
A1 = “Document Title”
A2:S2 = “Labels”
<o> </o>
I want on the right side of each cell, A2:S2, a “drop-down-arrow” that sorts all the “Data” by the particular column selected. Such that if I click on A2’s “drop-down-arrow” would allow me to select; Ascending, Descending, or any particular “Data” item in the range A3:A2084. The last option of which, when selected, will show only the items in the entire range that have that particular data item in column A.
<o> </o>
A3:S3084 = “Data”
<o> </o>
How do I best set up the worksheet so that it can be easily sorted as I described above?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
EXAMPLE WORKSHEET
A1 = “Document Title”
A2:S2 = “Labels”
<o> </o>
I want on the right side of each cell, A2:S2, a “drop-down-arrow” that sorts all the “Data” by the particular column selected. Such that if I click on A2’s “drop-down-arrow” would allow me to select; Ascending, Descending, or any particular “Data” item in the range A3:A2084. The last option of which, when selected, will show only the items in the entire range that have that particular data item in column A.
<o> </o>
A3:S3084 = “Data”
<o> </o>
How do I best set up the worksheet so that it can be easily sorted as I described above?