Find Row in Table based on Column Header

It will be much easier to provide specific solutions if you attach a sample workbook, so we can see your data structure.

Thanks for the reply.

If you run the macro, a userform will pop up. The combobox value is selected by the user. The listbox will be already populated in the original workbook.

I want to search for the header in the table that corresponds to the combobox value and find the row for the first value in the listbox.

Ultimately, what I need to do is find the first and last rows in the column for all the items in the listbox. But, if I know how to do the first task, I can figure out the rest.

So, in this example, say Merchant Group is selected, I want to find the first row (and eventually last row) with that first item in the listbox (Automotive).

Okay - try this:

Please Login or Register  to view this content.