A set of VBA macros for Excel automation: Import, Process, Update, PDF, Backup
1. DATA IMPORT
This macro collects data from all sheets of all Excel files in the selected folder and places it on a new sheet. Adds the first two columns: file name and sheet name
2. DATA PROCESSING
Cleans and prepares the Active Sheet data for typical situations for further analysis
3. REFRESH
Refreshes all pivot tables in the file, all Power Query queries, and recalculates all formulas
4. PDF
Exports data from the Active Sheet to PDF and saves the PDF file to the current folder with the current date and time
5. BACKUP COPY
Creates a "Backup_Copies" folder, where it places a copy of the file with the current date and time
FOR WHO
Analysts, accountants, managers, reporting specialists
BENEFITS
Time savings, no need to write code, ready-made solution
WHAT´S INCLUDED IN THE PURCHASE
1. A ready-to-use file;
2. PDF instructions with a detailed description and Print Screen for each macro;
3. Support (ready to answer questions if needed)
No feedback yet