VBA Macro Automation Script for 100+ Excel Data Processing
Budget: ₹1,500 – ₹12,500 INR
Develop a VBA Macro Automation Script that can process and search through multiple folders and subfolders containing 100+ Excel files across different brands. The script should automatically read all Excel files from all specified directories and ensure that no file is skipped during processing.
The objective is to compare the IMEI values from a target Excel file against the IMEI records available in all source files. For each matching IMEI, the script should:
Search all Excel files within all folders and subfolders.
Match the IMEI number with the target file.
Verify that a valid Sell Out Date exists for the matched IMEI.
If both conditions are satisfied (IMEI matched and Sell Out Date found), automatically populate the corresponding Sell Out Date and Purchase Price with GST in the designated columns of the target file.
If a matching IMEI is found but the Sell Out Date is blank, null, or not available, do not populate the Purchase Price with GST and ignore that record.
If the same IMEI is found multiple times across different source files, the script should identify all matching records and use the oldest (earliest) Sell Out Date. The corresponding Purchase Price with GST associated with that oldest Sell Out Date should be populated in the target file.
Continue processing until all IMEIs in the target file have been checked against all available source files.
Key Requirements:
Support processing of 100+ Excel files.
Read all folders and subfolders automatically.
Process files for all brands without manual file selection.
Ensure every Excel file in every folder is scanned and searched.
Perform efficient IMEI matching across all source files.
Validate the existence of Sell Out Date before updating data.
Populate both Sell Out Date and Purchase Price with GST in the target file for valid matched records.
Ignore records where Sell Out Date is not available.
Handle duplicate IMEI records by selecting the oldest available Sell Out Date.
Optimize performance for large datasets and minimize processing time.
Provide detailed logging and error handling to identify skipped, unreadable, or corrupted files.
The objective is to compare the IMEI values from a target Excel file against the IMEI records available in all source files. For each matching IMEI, the script should:
Search all Excel files within all folders and subfolders.
Match the IMEI number with the target file.
Verify that a valid Sell Out Date exists for the matched IMEI.
If both conditions are satisfied (IMEI matched and Sell Out Date found), automatically populate the corresponding Sell Out Date and Purchase Price with GST in the designated columns of the target file.
If a matching IMEI is found but the Sell Out Date is blank, null, or not available, do not populate the Purchase Price with GST and ignore that record.
If the same IMEI is found multiple times across different source files, the script should identify all matching records and use the oldest (earliest) Sell Out Date. The corresponding Purchase Price with GST associated with that oldest Sell Out Date should be populated in the target file.
Continue processing until all IMEIs in the target file have been checked against all available source files.
Key Requirements:
Support processing of 100+ Excel files.
Read all folders and subfolders automatically.
Process files for all brands without manual file selection.
Ensure every Excel file in every folder is scanned and searched.
Perform efficient IMEI matching across all source files.
Validate the existence of Sell Out Date before updating data.
Populate both Sell Out Date and Purchase Price with GST in the target file for valid matched records.
Ignore records where Sell Out Date is not available.
Handle duplicate IMEI records by selecting the oldest available Sell Out Date.
Optimize performance for large datasets and minimize processing time.
Provide detailed logging and error handling to identify skipped, unreadable, or corrupted files.