Alert and filtering based on conditional formatting VBA

[clapforthewolfman]

Hi all,

Looking for some help with VBA. I want to build a macro that runs when the workbook is initialized that will filter a sheet based on a due date (where the duedate<= Today()+90). What the Macro should do is filter the worksheet so that only the records with due dates in this range will be displayed and possibly throw in a message box "Projects due in the next 3 months".

Any help with this would be greatly appreciated!

Thanks,

Wolfman

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[clapforthewolfman]

Here is a sample workbook. So what I need to happen is that when the workbook initializes it filters the column based on the date. Conditional formatting rules can be viewed. The macro should filter based on these same rules I think. Let me know if you need anything else. I will be working on this today as well so hopefully can come to a solution!

Thanks,

Wolfman