Solved: Filter Records before sending to userform

[MRichmond]

Good day to you all.

I have a workbook that contains a userform and a worksheet to hold the data user's enter.

Everything currently works as it should (thanks again XLD), but now I've been asked that instead of the userform displaying all records, it should only display records that have not yet been resolved (Column Y = "").

In the sample work book I would only see records 4,5 & 6 (rows 5-7) when I scroll through the records.

Does anyone know how I can modify the existing code to achieve this please?

Thanks in advance for the help

[Bob Phillips]

Try this

[MRichmond]

Thanks XLD,

I was confused at first, as the records I didnt want to see were the only ones I could see, but I was able to figure out where the change needed to be made and now it works great.

Thanks again for you assistance.

[Bob Phillips]

Oops, yes I showed the resolved ones didn't I

[MRichmond]

Hey no problem, at least this time I was able to see how to fix it myself.

[Bob Phillips]

Did you test it for blank or not equal Yes?

[MRichmond]

I tested for Blank, and made the field either Yes or blank entry.