Random 12 sample with no duplicates and 1 condition

[willow1985]

Hello

I need help with acquiring a random 12 numbers from Column A in the blue table (right). No numbers can be duplicated on the list (column A on the left) and I need the formula to only select Work Order numbers that have an "N" in column E in the table (right)

(see below picture)

I hope I am explaining this well...

Thank you to anyone who can help

Carla

 

[willow1985]

Your last post (#13) said you were closing this "post" (which I took to mean this thread) and would start a new one. So I did not think you were looking for a further response here nor am I sure we know all of your code for this project so we might not know how to respond without more information. Did you start a new thread yet?

I did start a new thread but have had no response to it and was surprised this thread is still going. I am still very green in VBA and cant figure out the mismatch error. Figuring this out is all that is left before my spreadsheet is complete but I can't seem to wrap my head around where the problem is...

 

[willow1985]

I figured it out. The code is fine and it was one sheet that was not selected.

Thank you guys again!

 

[Rick Rothstein]

Great! Glad to hear you have everything resolved.