Виконано

EXCEL/VBA APPLICATION

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.

Features:

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.

Навички: Обробка даних, Excel, Visual Basic

Деталі: vba excel programmer job, vba excel programmer, programmer excel vba, need of excel programmer, i need a vba programmer, excel to application, excel programmer job, excel macros need programmer, custom list in excel, vba time, vba create folder, vba codes, vba and macros, excel vba or, excel vba and, excel mark, create folder vba, excel spreadsheet programmer, vba projects, vba programmer, VBA Macros, vba excel macro, need vba programmer, Macro vba, excel/vba

Про роботодавця:
( 71 відгуки(-ів) ) North Fort Myers, United States

ID Проекту: #5391744

Доручено:

gokulanand

Hello, I read through your requirements and everything looks like familiar to me. I had done similar kind of assignments before. You can check out my past projects and reviews. I can make sure that the job gets done Більше

$200 USD за 1 день
(102 відгуків(-и))
6.1

12 фрілансерів(-и) у середньому готові виконати цю роботу за $186

deepbluetech

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

$250 USD за 3 дні(-в)
(198 відгуків(и))
7.3
caabdul

Greatings! I can do this job with perfection. Thank you

$147 USD за 4 дні(-в)
(53 відгуків(и))
6.0
FIBIN

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac Більше

$225 USD за 3 дні(-в)
(53 відгуків(и))
5.5
vikas0903

Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on Більше

$94 USD за 3 дні(-в)
(39 відгуків(и))
5.6
SteveP495

Hi, I build robust, strategic business solutions period. I'm not cheap. There's a reason for that... PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Exce Більше

$325 USD за 6 дні(-в)
(6 відгуків(и))
4.9
srdas2012

Hi, We are Expert in Word and Excel Macro VBA/VB6/VB.Net can bring almost VB6 in Macro. We would like to do these Macro for you. We can Export data from even word tables to Excel apart from regular text export. Більше

$136 USD за 7 дні(-в)
(23 відгуків(и))
4.8
richardst

Hello, Sir. I have carefully read your project description and i am sure i am suitable to your project. I have developed many excel and other office programs for macros and addins using VBA and .NET(C# and VB.NET Більше

$111 USD за 3 дні(-в)
(5 відгуків(и))
3.5
man25

I am good at VBS scripting. I need the first project in freelancer, could you give me a chance, thank you.

$144 USD за 3 дні(-в)
(4 відгуків(и))
3.2
mailsmaity

I can do that... I can even finish before 10 days..Its only for buffer.. Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you Discuss more on PM Більше

$111 USD за 10 дні(-в)
(1 відгук)
0.6
gskur

After the project specs are made clear and unambiguous, it will take one or two days to complete. Gene

$333 USD за 2 дні(-в)
(0 відгуків(и))
0.0
fdjunior

I work with this kind of project every day in my current job. You can be sure that i know what you need. I just going to need a exaple of the .csv file (just to see the sheet struct). I also going to need that you tel Більше

$155 USD за 4 дні(-в)
(0 відгуків(и))
0.0