populating a listbox

[boltjoa]

Forgive me for being a novice on listboxes. Here's what I want to do. When a user clicks commandbutton1, I want a listbox to populate. The data being pulled is from sheet PNMs. However, I want to be specific. I'd like only the data populated if the text in column A is "Active" and I want all the corresponding data through column K shown. So, if row A2 says "Active", then I want B2, C2, D2, etc. etc. to show up on the row of the listbox. Does that make sense?

here's the final kicker. I'd like to then sort the data based on column B to show in the listbox from highest to lowest. Column B is a number format

thanks!!!

 

[boltjoa]

anybody????