Statement of account https://www.dropbox.com/s/kdz4pk6s70...2013-2014.xlsx
Source data https://www.dropbox.com/s/kdz4pk6s70...2013-2014.xlsx
On the "Statement of Account" I select a client by clicking their name (first line of the address section, with the idea that this will query the sales sheet (source data), and list all invoices for the year for that client. The formula works for one month, in this case April 2013, but I need it to query all months (April-March), and I'm a bit stumped.
Thank you for your wisdom!
Bookmarks