Context:
I have a huge spread-sheet such that rows/records are considered "jobs," where columns are aspects of the job like location. One such column P, titled File-Name, that lists the pdf-file-names of invoices. This contains duplicates as some jobs are combined into one invoice. EX: 6022.pdf
I have another spread-sheet, Invoice Submission Summary, whose only purpose is to behave as a report to grab information from the Jobs-spread-sheet.
The way I go about doing this is by obtaining a list of all the file-names of invoices in the invoice-folder on my Windows computer. Then pasting them into a range on the Invoice Submission Summary spread-sheet (a separate spreadsheet from the jobs one). I then use a filter-formula that uses the pasted-range as criteria for the P column in the Jobs-spread-sheet.
Problem:
In the Invoice Submission Summary spread-sheet I have to reference every cell individually in the pasted pdf invoice-name range inside of the filter formula. ( Because of this it is 1800+ characters long now and it's also very slow.
Goal:
I want to rewrite the formula to be less complex, and not require to be updated every time I paste a longer list. Or find an alternative way to accomplish generating a report for printing purposes from a different spread-sheet.