Forum Discussion
Transfer Quicken Data into Weekly Report
| 1/2/2024 | 1893 Res | PAYPAL TRANSFER 240206 | Tithe | 650.15 |
| 1/3/2024 | 1893 Res | PAYPAL TRANSFER 240213 | Tithe | 96.62 |
| 1/4/2024 | 3022 Youth | DEPOSIT MADE IN A BRANCH/STORE | Donation | 25 |
| 1/4/2024 | 2104 Main | DEPOSIT MADE IN A BRANCH/STORE | Tithe | 0 |
| 1/8/2024 | 2104 Main | DEPOSIT MADE IN A BRANCH/STORE | Tithe | 690 |
After converting CSV into Excel format and filtering the above, the data represents what must be placed into the appropriate account (column), totaled, and then totaled into weekly segments.
We need a formula for a year's worth of data to accomplish this task. There are two other columns not included: 9542 BkSt, and Bldg Fund
| Week Ending | 2104 Main | 1893 Res | 3022 Youth | Total |
| 1/1/24 - 1/6/24 | ||||
| 1/7/24 - 1/13/24 | ||||
| 1/14/24 - 1/20/24 | ||||
| 1/21/24 - 1/27/24 | ||||
| 1/28/24 - 2/3/24 | ||||
| 2/4/24 - 2/10/24 | ||||
| 2/11/24 - 2/17/24 | ||||
| 2/18/24 - 2/24/24 | ||||
| 2/25/24 - 3/2/24 | ||||
| 3/3/24 - 3/9/24 | ||||
| 3/10/24 - 3/16/24 | ||||
| 3/17/24 - 3/23/24 | ||||
| 3/24/24 - 3/30/24 | ||||
| 3/31/24 - 4/6/24 | ||||
| 4/7/24 - 4/13/24 | ||||
| 4/14/24 - 4/20/24 | ||||
| 4/21/24 - 4/27/24 | ||||
| 4/28/24 - 5/4/24 | ||||
| 5/5/24 - 5/11/24 |
Re:After converting CSV into Excel
Can you share the raw .CSV file?
You may upload to above cloud drive.
https://gofile.me/7fyIV/5lIv4Vrai
Show page as above screenshot.
Re:
Received Msg Blocked with your link
What has been blocked?
