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
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