Forum Discussion
Trying to create a document that updates information based on specific information in workbook
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
=FILTER('Customer Information'!D:F,'Customer Information'!C:C=A6)
Does FILTER return the intended result?
=FILTER('Customer Information'!D:F,'Customer Information'!C:C=A6)
Does FILTER return the intended result?
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.
