This is my first post here, although I've benefited from many great solutions on this forum. Unfortunately, I haven't been able to adapt any of them to my current problem yet.
I have a workbook with over 20 worksheets for different products that are managed and updated by different users. Data structure is consistent across these sheets, and I am trying to come up with a formula to summarize it. A simplified version is attached.
The desired outcome is to create a dynamic list of any product that has been ordered (has a delivery date or order number), but either hasn't shown up or hasn't been invoiced yet.
It would be great if these could be in date order, even though several rows might have the same delivery date, the combination of data within the row will be unique.
I've tried to get to this with INDIRECT to look through multiple sheets. Truthfully, I don't have a good enough understanding of INDIRECT or array formulas to get a working solution.
I'm hoping someone can help point me in the right direction.
Thanks in advance!
Bookmarks