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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,137,294
Messages
5,680,654
Members
419,923
Latest member
Kalthus

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