Automated data conversion from CSV file to Excel
Abdul Wahab Abdul Qadees
Our Accounting Team was not able to obtain Accounting Records in Excel, specially the General Ledger break-ups in order to successfully analyze the entries in details, using filters and various formatting options. I found the opportunity to automate this process of downloading the records in CSV & HTML formats, and converting them into analyzable and user-friendly Excel Sheets, for ease of use to see how a complete double-entry was made in the system.
Like this project
Posted Oct 11, 2024
With the help of VBA, conditional formatting and various other formulas, I was able to program Excel to convert the raw information into more readable format
Likes
0
Views
0
