PDA

View Full Version : Copy paste filtered range with criteria using VBA



Jayant123
12-10-2014, 10:46 AM
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

Jayant123
12-11-2014, 06:27 AM
Please can some one address it ?

Thanks