Forum Discussion
Rudrabhadra
Jun 22, 2023Brass Contributor
Criteria based
I wish to get separate tables based on the value in cell B1:K1 through VBA.
Eg: for “A” the table shall appear 1,7,10,13,17,20,21
And for “F” the table shall be 1,2,3,4,5,6,7,8,9,10,20. I wish to get tables populated based on the criteria given in sheet 2.
Test sheet attached.
Rudrabhadra Assuming you use Excel 365, see attached.
- JKPieterseSilver Contributor
- RudrabhadraBrass ContributorThanks...