I have several sheets in workbook and I want to combine all search column into new one.
In the column A of the first sheet I have a list of values that must be search in these several sheets. This list does not contain duplicate data.
The sheets can be 3 or 4 max 5.
I found this post here. The solution is ok
https://www.mrexcel.com/forum/excel-questions/583666-search-value-column-copy-row-new-sheet-all-matching-values-new-sheet.html
but I should make sure that the data to be serached for take it from column A in sequence cell after cell and write me the result in the new sheet
If it takes a long time it does not matter ...
The result should therefore be the list of rows containing the data in column A, found in the sheets in this workbook.
Example Base File
Best Regards
In the column A of the first sheet I have a list of values that must be search in these several sheets. This list does not contain duplicate data.
The sheets can be 3 or 4 max 5.
I found this post here. The solution is ok
https://www.mrexcel.com/forum/excel-questions/583666-search-value-column-copy-row-new-sheet-all-matching-values-new-sheet.html
but I should make sure that the data to be serached for take it from column A in sequence cell after cell and write me the result in the new sheet
If it takes a long time it does not matter ...
The result should therefore be the list of rows containing the data in column A, found in the sheets in this workbook.
Example Base File
Best Regards