I have been trying everything on the internet for the last 2 weeks to find a solution to a seemingly easy problem. Maybe I am looking down the wrong path. Hope someone can chime in with some advice. Heres what I am trying to accomplish.
I have a userform multiselect listbox populated by rowsource in VBA that shows 12 columns per row (It intentionally does not show the 13th column). I would like to filter the table on sheet "ms" to only populate the listbox with all rows that are blank in column 13. Currently I am using autofilter to send the filtered data to a helper sheet and populating the listbox from there. Is it even possible to avoid using the helper sheet? The reason I want to do this is when I select rows in the listbox, it is supposed to add an "X" in column 13. What is happening is the row index on the Original table does not correspond with the filtered data so it puts the "X" on the wrong row if at all. Here is a quick mockup.
I just for the life of me cannot figure out how to accomplish this in each selected row. Can anyone help me?