Hi,
So I'm working with a huge set of pdfs that I'll be importing into excel using power query. That part is very straightforward but the second part is what I've been having trouble with.
I basically need to:
1. Search for 1 keyword in a LIST of keywords (in any column from a single worksheet)
2. When that keyword is found, note every column it appears in (column f, column g...)
3. Apply a filter for one column (F) using that keyword
4. Copy the entire row that they keyword appears in
5. Then paste it into a new worksheet
I imagine this would use a lot of loops!
Step 4 and 5 need to repeat for every column that is found in step 3.
After (step 5) all the columns are searched in, It should go back to the LIST in step 1 and repeat the whole process for the 2nd keyword. And repeat until the entire process is repeated for every keyword.
So I'm working with a huge set of pdfs that I'll be importing into excel using power query. That part is very straightforward but the second part is what I've been having trouble with.
I basically need to:
1. Search for 1 keyword in a LIST of keywords (in any column from a single worksheet)
2. When that keyword is found, note every column it appears in (column f, column g...)
3. Apply a filter for one column (F) using that keyword
4. Copy the entire row that they keyword appears in
5. Then paste it into a new worksheet
I imagine this would use a lot of loops!
Step 4 and 5 need to repeat for every column that is found in step 3.
After (step 5) all the columns are searched in, It should go back to the LIST in step 1 and repeat the whole process for the 2nd keyword. And repeat until the entire process is repeated for every keyword.