Make a scheduler in excel to trigger automatic generation of report at regular intervals.
Code should automatically identify the latest raw data file from a predefined folder based on timestamp and pick it for further processing.
Pick up the excel file and add additional business logic to entire set of data
Save the excel file as csv format in predefined network folder
Keep a log of the files processed with date/time of processing.
Code should automatically keep checking for newer files every 10 minutes (time should be custom and can be changed)