Xavierstram
New Member
- Joined
- Aug 9, 2019
- Messages
- 1
https://1drv.ms/u/s!AmfNhO-qyFc5iSnpBImBa6_Ndu_U?e=U3dbXq
Screenshot in the link above
I'm trying to create a function so that the bills in the top left will auto-generate into the table for the different weeks. For example if a bill falls between the 1st-10th than i would like them to automatically populate in the Week 1 Section on E17 and go down sequentially. If I have to add a bill on the left than it will auto include into the tables in the appropriate week based off the day the bill is due. and continue all the way for the rest of the table. so week 2 would be between 11-19. week 3 20th-25th etc.
Been numbing my brain trying to figure this out.
Screenshot in the link above
I'm trying to create a function so that the bills in the top left will auto-generate into the table for the different weeks. For example if a bill falls between the 1st-10th than i would like them to automatically populate in the Week 1 Section on E17 and go down sequentially. If I have to add a bill on the left than it will auto include into the tables in the appropriate week based off the day the bill is due. and continue all the way for the rest of the table. so week 2 would be between 11-19. week 3 20th-25th etc.
Been numbing my brain trying to figure this out.
