Criteria based

[Rudrabhadra]

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.

[#2 · Accepted solution]

@Rudrabhadra Assuming you use Excel 365, see attached.

[#3]

Thanks...