Est. Budget: $10.00
I have a job list on one sheet and a list of jobs and emails on another. I want to filter the list on the first tab based on the jobs on the second and send the filtered page to people in the email list.
So on P2, grab job number, filter list on P1 and email to address on P2 corresponding to job number.