Can this be done?

burnshroom

New Member
Joined
Apr 11, 2012
Messages
1
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.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,171,683
Messages
5,876,884
Members
433,217
Latest member
Muhammad Tanzeel Ur Rehma

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top