Hi folks,

First post so be gentle

Need to add a few buttons to my sheet so that I can essentially filter the data quickly with one click and shows the relevant rows.

VBA Buttons seem the best idea.

I need to write the VBA code so that when button 81 is clicked, it filters the sheet to show work outstanding based on dates in K5:K171. Basically anything with blank or a date between today and 01/01/2005.

Second button is to show work due again using data in K5:K171. Work due will be anything with a date between 01/01/2005 and 30 days in the future.

If only I had to use VBA everyday this would be so much easier - I use it so infrequent I tend to forget how to do things