How to return data from a list of daily transactions into a different format
I have a table that contains daily disbursement transactions complete with accounting journal entries, from which reports and Journals are generated. How do I transfer the data from this list into the Check Disbursement Journal? I used the SUMIFS formula but what is the formula to automatically return the account titles under the sundry column when I manually enter the check numbers? I have attached the sample data table and Journal.
|