Forum Discussion
How to auto-populate all values of the row in a new excel sheet if two keywords are found in the row
Hello all, I want to know if it’s possible to auto populate all data present in a row in a new excel sheet if the row from which I need to copy has two keywords. for instance if the workbook...
If you have Microsoft 365, you can use the FILTER function to return rows from a worksheet that satisfy some conditions, and VSTACK to combine the result of FILTER from multiple worksheets.
If you'd like help with that, please provide more detailed information. For example: in which column (or columns) should we look for the keywords?