Hi
I am kindly asking for help to produce Account balances using information from Payment and Receipt sheet.
The solution should be able to capture about 5500 records.
Find the attached excel sheet.
Regards,
Sunboy
Hi
I am kindly asking for help to produce Account balances using information from Payment and Receipt sheet.
The solution should be able to capture about 5500 records.
Find the attached excel sheet.
Regards,
Sunboy
If this presentation works for you then look at the workbook attached.
Excel 2016 (Windows) 32 bit
A B C D E F G H 1Customer Name Date Invoice Amount Incl VAT Receipt.Date Receipt.Receipt Receipt.Amount Balance 2John 1/10/2020C0020 1145 1/12/2020R100 1145 0 3John 1/12/2020C0023 1030 1/19/2020R103 700 330 4John 1/14/2020C0025 1050 0 1050 5Mary 1/10/2020C0021 1010 1/13/2020R101 900 110 6Mary 1/14/2020C0024 1040 1/20/2020R104 1040 0 7Henry 1/12/2020C0022 1020 0 1020
Sheet: Sheet1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please try
Please Login or Register to view this content.
Hi Roy_Ry and Alansidam
My apologies for late replying, I was offline. There was network problems in my area. Thank you for helping me. Roy_Ry's presentation works for me, but when I add more payments and receipts sheet ALL is not updating. How do I make it up date?
Regards,
S. Moyo
After loading new data to the source, be sure to click on the Refresh All Icon on the Data Tab.
Hi Alansidam
Thanks, I have done that but it has been a while it is still saying updating in the background.
Regards,
Sunboy
Hi Alansidam
It has finished updating its working well. Thanks a lot.
Regards,
Sunboy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks