Want to automate Interest process, currently prepare the interest table manually by inputting the required data which is time consuming.
I have raw data which is required to prepare interest table, raw data contains various headers. There is header name "TYPE" under which there is "MO" means money out or payment and "MI" means Money in or receipt of funds from the client.
There is another tab which Interest rate in which all the interest rate for the month is present
I have attached the required data through which i prepare interest table, is there any way through VBA macro that the process can be automated.
have attached the interest table for review, which will tell the actual picture the way we want.