Can this be done?

[burnshroom]

I am a long time member here (I think), but I believe this is my first time posting.

I am NOT very versed in all things excel but use it a lot, but probably not the best way.

I use excel to basically setup a bill pay scheduled based on family income on a biweekly basis, but have to update it manually from week to week.

I am wondering if is possible via vba to automate this. I have a end result in mind but I cannot get myself to come with a way to do it, nor a template that someone else has set up to use.

What I am trying to do is to have excel automatically, on a new worksheet, to setup a new 2 week calendar. Then based on what bills were paid the prev 2 weeks setup a new 2 week schedule within x amount of dollars. I would also like it show in adjacent cells a) how much was paid last time, b) when it was last paid and c) the average of the last 3 payments.

I would also like it to auto archive at certain points so it doesn't bloat the file.

I see that this is a lot and was wondering if it is possible, and if so where I should start.

Or if I should just tough it out manually as I have been doing.

Thanks in advance.

 

[BIGTONE559]

would require some time/thought but definitely possible