[Help] Narrowing search results prior to populating listbox

[Compo]

I have a working search routine which I would like to have filtered and have no idea where to start with it.

Please Login or Register  to view this content.

My idea is that I would like only to populate the listbox with results where worksheet rows have no data in all four of columns 10, 12, 13 and 14. Currently data is returned from all rows but the listbox results are only used for the updating of one or more of those four columns.

As I am almost entirely new to programming of this type I don't even know if it is more efficient to narrow the data for the search or to perform the search and narrow the results so any help would be appreciated.

Thank you in advance.

[Richard Buttrey]

Hi,

The way I'd approach this is to use a helper column in your data which identifies whether cells in columns 10,12,12& 14 are all empty. Then first get the macro to perform an advanced filter, and filter the columns you want for your list box to a temporary area, then use this temporary area as the range for populating your Listbox. If you create a dynamic range name for the temporary area you can then use the name to populate the list box.

Hope this helps

[Compo]

Sorry for the delay in getting back to you on this.

I've just read your response and I'd like to clarify something because it seems as if you may have misunderstood my poorly worded question.
I need all of the columns in my listbox, (it populates entire rows for reference as it should), not just those which may be updated.

What I need is the current results narrowing. Instead of outputting every row in the worksheet which match the search criteria, I would like to populate my listbox with just those which match the criteria and have no data in all of those four columns.