How to return data from a list of daily transactions into a different format

Marcia · #1 07-05-2018, 02:20 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting daily data to annual	jahan	Excel	1	05-30-2017 07:11 AM
Return List Based On Specific Value	Helmszee	Mail Merge	1	04-12-2016 02:30 AM
Return Value from Drop-Down List	bartleby	Excel	0	01-20-2016 07:45 PM
Excel Validation Feature to Return Items from a List	summerabc	Excel	1	01-16-2015 04:37 AM
Combining daily S.M.A.R.T data in a meaningfull sheet (2 problems)	Vitolio	Excel	1	07-10-2013 08:58 AM