PDA

View Full Version : sorted data



tofimoon4
01-25-2011, 05:31 AM
Dear sir,with best regards, i need your help to sort the data mentioned in attached file according to the options mentioned in (Q1,Q2) cells (by a code).
Many thanks in advance.

mikerickson
01-25-2011, 07:11 AM
It looks like AutoFilter will do what you want.

"Sorting" means putting data in order, e.g. turning cat, bird, dog, beast into beast, bird, cat, dog

"Filtering" means showing only some of the data, e.g. showing only bird and beast from the example above.

tofimoon4
01-25-2011, 10:48 PM
Dear sir,with my thanks,I think I did not succeed in expressing , what I want is to filter the data within the table to show me only (for example) the desired inv. or just the selected agent that mentioned in (Q1&Q2) cells.
I hope my request is clear now.
My appreciation.

mikerickson
01-27-2011, 12:30 AM
Setting up Q1 and Q2 for that purpose duplicates the functionality of Excel's built-in AutoFilter.

tofimoon4
01-27-2011, 03:45 AM
Dear sir,with thanks,you mean there is no code to do what i want,please.

mikerickson
01-27-2011, 08:13 AM
I mean that filtering the way that you want is inefficient. While one could code things to work as you request, that would be an inferior spreadsheet to one that uses AutoFilter.

tofimoon4
01-28-2011, 11:09 PM
Dear sir,many thanks for advice.