A set of VBA macros for Excel automation
Content: Набор макросов VBA для автоматизации Excel.xlsm (53.21 KB )
Uploaded: 06.01.2026
Positive responses: -1
Negative responses: 0
Sold: -1
Refunds: -1
Seller: Tomash100
$2.35
Description
- 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)