Copy paste filtered range with criteria using VBA

I have two sheets interface and database

What i need to do is extract 6 columns viz


Supplier Name / Origin / Ordered by / Inv Type / Bank / LC opened Amount


in the interface sheet from the database sheet

　
There are two option buttons

Order placed and Tr maturities post which the user can select related respective months

based on the month selected starting and ending date shall form the criteria for the month to be filtered

if the user selects order placed the column which needs to be filtered is column G (Rqst date ) in the database sheet , and above 6 column needs to be filtered / copied and then pasted in the interface sheet


if the user selects TR maturities the column which needs to be filtered is column Z (TR month ), and above 6 column needs to be filtered / copied and then pasted in the interface sheet

I have done the same with formulas in the attached sheet , the problem is as the data grows , the sheet will become dead slow , request some one to please help me with a VBA code in doing this

I am attaching the file for easy reference


regards

hi Jayant shettigar, option, please check attachment

Originally Posted by watersev

hi Jayant shettigar, option, please check attachment

Sir

Amazing that is exactly what I wanted , a small problem being it clears all the contents of columns on its left hand side where currently I have set data for data validation. G10 to I22

Cant the code just clear the table range say S12 to x1000 while displaying the output

also along with the existing filter, I want to add one more filter say ordered by which is in cell x10 in the interface sheet

I am adding the sheet for you reference

I really appreciate for your efforts in devoting your valuable time and responding god bless



regards

the code would clear only S12:X... range on Interface sheet. The rest from your post requires further explanations.

Sir
My sincere apologies if i was not clear in explaining , if you refer the order monitor_1 file which i have attached in my second reply clearly shows that when i run the code given by you month details being used for data validation gets deleted , post which we cannot select any other months

Kindly refer the order monitor_1 file

the same file also explains the additional condition which needs to be incorporated in the VBA code
Thanks

file in post #4 has corrected code which deletes only result data in S:X columns.

File from your post #3 does not explain anything to me, sorry