extract few columns based on condition and paste on another worksheet

Hi folks,

I am quiet new to macros, reaching out to the experts community for the support.

Please see attached the sample data. I have all the data in "Sheet1". I need on the click of "Projects Overdue" button at "Sheet2", the query will extract all the overdue projects information (columns C, D & F) from "Sheet1" and paste the data in the table highlighted on "Sheet2". Hope I am clear with the requirement.

Many Many thanks in advance....

Kind Regards,
Abhi

Hi nankw83,

Thank you, Thank you, Thank you.

This code is absolutely working fine. The only thing, if I also want to place a filter on the estimated savings i.e. only to pull out top 5 (higher values) on "sheet2".

Apologies for not mentioning the first time as just now realized after getting the big list extracted.

Kind Regards,
Abhi

Thank you nankw83. This helps and suffice the purpose.

Regards,
Abhi