Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Hello, how can i create a workbook for a savings and credit cooperative which can auto update with years, past,present and future months basing on member id or account names and payments made of deposit,savings,personal account,loan recieved,loan payments and its infinite with years and months, years ranging from 2023 to infinite same as the months.   thank you.




Hi Makunku and welcome to the Forum.

How do you do that? With some thought and hard work! (But see my final paragraph.) 

The Forum is generally for (relatively straightforward) questions and answers; users shouldn't define a mini-project and expect us to deliver a solution. We expect you to have made an attempt first (preferably attaching that Excel file to your question, using the Add Files button when you create or edit it- but don't include personal details).

You may be lucky and someone will provide a starter file but we don't know anything about your cooperative, its numbers, loans (repayments/ formulae/interest rates etc).

You should forget the concept of "infinite" years incidentally - that's impractical (since Excel has row and column number limitations) and 80 years (say) will probably outlive Excel.

Not sure what your national laws are (Kenyan?) but, in the UK and many other countries, financial institutions are generally highly regulated and use specialist software to record and control transactions. For that reason alone I won't suggest a solution nor recommend that others do. 



@ John_Ru:

Great post. My thoughts exactly.

Cheers   :-)
WillieD24 (rep: 382) Mar 14, '23 at 12:14 pm
@Willie- thanks. It's not a classic Forum answer but I thought it best to avoid more correspondence on a tricky subject. 
John_Ru (rep: 5722) Mar 14, '23 at 12:42 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login