VBA code to find blanks and populate corresponding unique row values

[chin67326]

Hello, please see the attached file. The command button in Sheet1 opens a userform. I want to click the button in the userform and have the below performed:

The code will search the 'Value' column in the 'infosheet' tab. Wherever there is a blank value cell, I want the corresponding Prefix value for that row to be populated in Label2 however ignoring/avoiding duplicates.

Therefore in the attached example, the Label2 should be populated with the below:

BATCH 2
BATCH 3
BATCH 9

Please help me with the code to achieve this task. Thank you!

[sintek]

What about BATCH 5

I suggest using a listbox and not a label...

Please Login or Register  to view this content.

[chin67326]

Yes BATCH 5 also

This worked great and thank you very much! Repped.

[sintek]

Glad to have helped...tx for rep +