hi,
i have a simple table with various criteria and 4000 odd entries which I want to filter properly. For example, 1 column has a long list of postcodes, and next to it, each postcode corresponds to an order date, in dd/mm/yyyy format - all on 1 worksheet.
I want to be able to link this data to another worksheet, where I can then pick out a particular area of postcode by searching for 2 letters, i.e. Oxford = 'OX'. And then it would show me the list of postcodes beginning with 'OX', along with its corresponding order date. From that list, I then want it to show out of those dates, only entries where the date is later than a certain date - for example, All postcodes beginning with OX with order dates later than 30/06/2008, for example.
So far all I've done is put a custom filter on each column, but there must be a more clever way of doing this, and without having to manually add filters.
Would really appreciate some help with this.
Bookmarks