Sep 04 2022 06:00 PM
Hi, I'm wondering if someone can help me.
I want data from spreadsheet B (invoice tracker) to auto populate lines in spreadsheet A (invoice request). Sounds simple and the FILTER formula I've applied =FILTER('Invoice Tracker'!N3:N58,'Invoice Tracker'!O3:O58>0) works to a degree.
My invoice tracker records multiple items designated by a code e.g.
code V1 is Visit 1 and there may be 6 of this item - the invoice tracker identifies 6 of that code and provides a total $ value.
I want to auto populate my invoice request (spreadsheet A) with each code that returns a value in my invoice tracker (spreadsheet B)
When I apply the FILTER formula above it will work when 1 code has a value but not when multiple codes do.
How do I correct this?
Thanks,
Rebecca :)
Sep 04 2022 07:17 PM
Sep 04 2022 07:40 PM