Automatically reapply filter based on date

Hey Guys,

After the last thread in which rows conditionally had to be copied out of a database into tabs, which succeeded thanks to the help on the forum, I want the database to be better organised. I'm looking for a macro which will automatically order the rows in the database according to the date of offer. Now reapply has to be used and I will think the people who will use this model will forget this.

I have not got any knowledge about macro's and when searching I found this one:

Please Login or Register  to view this content.

So the database-order needs to be adjusted dependent of the data in column B. The code was intered in the 'view code' screen of the database tab. I hope I made my question clear and you can help me with this one.

Looking forward to an answer,
Floris

Hi Floris
a pivot table will do the trick