Need to learn how to develop application using C# or VB with Excel & Access

[MGadAllah]

Hi,
I do not know if this topic is suitable for the forum or not but I do hope if there is any insights or recommendations for what shall I do.
I am working as a budget accountant and using Excel for daily tasks at work.
I add balances for different departments in the 01-01-2017 and record expenses for each department till 31-12-2017.
I deduct each expense from each department's balance and make sure it has enough balance (money) otherwise I refuse to approve the expense.
I am using 2 Excel workbooks (1st titled DataEntry.xlsx) and (2nd titled Reports.xlsx).
I add the balances for each department in the DataEntry.xlsx workbook.
I added each expense for each department in the DataEntry.xlsx workbook.
I check the balance for each department from the DataEntry.xlsx workbook where I created pivot table and using calculation fields to know the remaining balance to check before I approve.
The data source in the Reports.xlsx workbook is a connection I created using the DataEntry.xlsx
Now I have a lot of departments and braches and different topics so I was thinking about creating or developing a software or application to help me.
I do not know coding at all but I want to learn and do this software to make my work easier because no one will assign this task to a developer at work and I do not have enough money to hire a freelancer and because I am not having a deadline I've thought or decided to do it myself as I know what I need exactly and this is a good thing I guess and I am interested to learn programing to do my task.
So where to get started? and will I need Access? or just Excel?
Also will I need to learn VB or C#?
Once again I am sorry if this off topic but I'm just used to get a lot of help for my work from this forum and this why I thought to ask about it here.

[dflak]

You can do a lot with "basic" Excel outside of programming.

The main advantage that programming provides is that it keeps you from doing a repetitive set of actions on a workbook. For example, each day, you might open another workbook, copy and paste data from it and then hide columns you don't want. This could be automated.

Another advantage of programming is that it can do something until a certain condition is met.

Some people tend to over program; they use VB when a basic Excel function will do. My philosophy is to do as much of the work as possible in the Excel Workbook and then use VB to stitch their pieces together.

I don't have the name of a good reference source for learning VB Code. All I have to offer is an aborted attempt on my part - it lacks the technicalities but it does set the framework for good coding practices. See the attachment.

Also, I recommend the following three articles to get the most from regular Excel
http://www.utteraccess.com/wiki/inde...Dynamic_Ranges
http://www.utteraccess.com/wiki/inde...ables_in_Excel
http://www.utteraccess.com/wiki/inde...Array_Formulas

I also recommend finding an on-line tutorial for Pivot Tables.