I don't need an exact answer, but would like to start down the right path.
I have a table of data (sheet1) with 500,000 rows and 12 columns. Column B is Store and Column D is Transaction.
I created a user form where one can input Store# in one text box and Transaction in a second text box. I need to create code to assign a macro button that will search down column B (store) and column D (Transaction). Where both input fields on the user form match both column B and column D on the same row, I want to copy the contents to another sheet.
I think I know how to search for one match in one column, but not multiple matches across multiple columns.
I have a table of data (sheet1) with 500,000 rows and 12 columns. Column B is Store and Column D is Transaction.
I created a user form where one can input Store# in one text box and Transaction in a second text box. I need to create code to assign a macro button that will search down column B (store) and column D (Transaction). Where both input fields on the user form match both column B and column D on the same row, I want to copy the contents to another sheet.
I think I know how to search for one match in one column, but not multiple matches across multiple columns.
