Automatical sorting

[Creativeboy4]

Hello all,

This is my second post here, and I am again asking for your help. So, here is the problem-

I have this huge excel sheet with lot of columns and information. I need to sort it based on my given information trough Microsoft Visual basic.

The idea is that I give a name so 1A check, and under the 1A check is the number from this workbook.

Example- 1a check , it gives out all numbers and other information.

Attached also pictures of 1A check( needed values)

these are the values(only card numbers) than need to be sorted out from the next picture that I uploaded

From this table I need to get that out. See column K, these are the numbers, but there is more than 1000 (K2:1268) , but defined in 1A check is only those that I gave in picture above.
Ask If something is not clear.

Thank you already before,

All best,

Creativeboy4

 

[Creativeboy4]

Maybe it is easier to use microsoft Access for this problem.