Audit Program 4.0 - User Manual
5. Importing Data for Deliverables:
5.4 Separating the Ledger Worksheets into Excel Files
C. Open the "Extraction Tool.xlsm" Excel File from Desktop
There are two functions within the “Extraction tool.xlsm” workbook.
1) Extract Ledgers
This first button, or tool, serves to extract the ledger excel worksheets from a combined excel file into separate files. Each extracted worksheet will be saved as a new standalone file, and renamed to the name of the worksheet from the combined workbook. Follow the instructions in the Extraction Tool workbook.
2) Create List of Filenames
The second button, or tool, serves to create a list of all extracted worksheets, so that you may copy this list of file names to the COA Mapping Form in the next step. Follow the instructions in the Extraction Tool workbook.
