Hi.
I am trying to generate a statement of account from a database. The idea is to enter the Customer ID in cell A1 (example), and have the list of invoice numbers, invoice dates and invoice values appear in columns B, C and D.
Any idea how I can achieve this? (Pivottable is not ideal).
Thanks.
Bookmarks