PDA

View Full Version : consolidate with two criteria uisng VBA



kimaya
06-03-2014, 06:57 AM
I am absolutely naïve to VBA but equally aware of its immense capability, I have a small problem I have three sheets AR , AP, TR where I am capturing the monthly maturities for AP and TR and monthly collections in AR sheet.
All the sheets have common number of columns , the common factor between this three sheets are 1) the status column which contains two status cleared and Not cleared and 2) bank where I have different banks
I need to apply two conditions in the first sheet (consolidate sheet ) where in the user will select first condition as criteria and the second condition as bank , based on this two criteria all the related information should get consolidated from all sheets to the consolidated sheets

I was able to apply the first condition that of criteria but need help in setting up the second condition of Bank can some on assist me


I am attaching the file with dummy data for a clearer understanding


Thanks