Excel Macro to Create Journal Entry based on Complex data and Save it in a New Folder

Hi Excel Experts,

I have this monthly reports that take much of my time and I wanted to simplify these by creating/ researching VBA code. I have just started this year learning this awesome VBA coding and just joined here to gain basic to advance knowledge from all of the excel experts. The old threads I read on this forum help me a lot and am looking forward to the excel experts out there.

In this regard, I would like to seek for your kind help on how to make my desired output works or any inputs from your end will be much appreciated. I have attached the sample spreadsheets for reference. You will see the criteria and desired output details on these workbooks.

Please do not hesitate to ask me by replying to this thread if you need additional details. Have a blessed day!


Warmest regards,
Arnel