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