Sep 11 2024 08:35 AM
I have a client list, some with multiple job names, requests related to job and mode of receiving said info. Those are the headings to my cells in the excel spreadsheet. What I would like to do is auto populate the information in a document that would be a running tab of correspondence for that particular job. I need to know how to copy over information(requests, mode, date) based on a particular cell (job name). Is there a formula for this. The following are images of my work so far
Sep 11 2024 12:18 PM
Solution=FILTER('Customer Information'!D:F,'Customer Information'!C:C=A6)
Does FILTER return the intended result?
Sep 12 2024 06:41 AM
This worked like a charm!!! Thank you so much my friend! When I tried FILTER command, I had them array and include mixed up and kept getting an error message. This is perfect. Thank you again for your response.
Sep 11 2024 12:18 PM
Solution=FILTER('Customer Information'!D:F,'Customer Information'!C:C=A6)
Does FILTER return the intended result?