Macro to filter future dates

[Abhijit2011]

Hi
I need help for a macro to filter specific future dates. For example in the attached sample sheet I have Product number in column A, Category in column B and expiry date in column C. What I want to do is to filter Column C when expiry date in next 60 days from today for all High and Medium category product only. And then copy the content and paste into different tab.
Could you please help?

[Sniper]

Hi

Here is something you can work with

[mahaveersomani]

check the attached file and press the button and see you result infront of your eyes and then ensure is it cool.....

If this was really helpful to you then dont forget to hit * button for user reputation

Regards
CA Mahaveer Somani

[xlbiznes]

One more to the collection of solutions.

Make a point to let others know, which suited your requirements the most.

[Abhijit2011]

Thanks all
All are working fine. One problem I ...cant add extra column to my master data sheet. The one from xlbiznes does not have extra column and i like the idea of input box. End part of the macro is little complicated though ( sorry i'm not very good at macro) and i'm having difficulty to implement it in my sheet. I'll take input from all the macros and will try to customized for my masted data. I'll get back with result soon...

Thanks again to all of you...you show me the path to develop my own one.....

[xlbiznes]

Hi,

Will your column heading for the expiry date be called "Expiry Date" ? . if yes, then we can apply the filter on that column based on its column heading.