Excel VBA Application
Objective: - To Create Excel based VBA application which does some macro based work and watch csv file for creation time and run specific codes and also refresh specific excel sheet.
1. Allow user to set source data folder in settings excel sheet or using vba setting box.
2. Allow user to set csv file names in settings excelsheet or using vba setting box. The macros button will use these settings.
3. Allow user to set custom calculation settings in setting excel sheet.
4. Create a VBA based Macro called Run Calculation , which will Create x number of excel sheet and import data from csv file and then do specific calculation and do conditional formatting and adjust the width of specific column. This it will do for all the csv file its listed on settings.
5. Create VBA based Macro where it will take specific column values from each sheet and display it on one spreadsheet as summary.
6. Create VBA based feature where it will monitor when the .csv data file is modified and any new file which has changed then update that excelsheet. Then it will mark that point, after that any new updates to specific data file in source folder then it will update them.
7. After the data file is updated it will list the updated file in separate window where it will list the file name and time it was updated, and when user clicks on the file name it will take the user to that excelsheet.
8. Allow user to set calculation & conditional formatting settings in settings excelsheet. All the calculation is very simple.
This is summary of specs. I need Experienced EXCEL/VBA Programmer who can get the job done on fastest time possible. If you work on multiple projects at a time please do not bid.
13 фрілансерів(-и) у середньому готові виконати цю роботу за $179
Hi, I have studied the requirement and can take on the job immediately. Would be helpful if you have sample csv files for my perusal. Let me know. Regards, Arul