I'm pretty good at programming VBA myself but I'm working on some other stuff.
- For a guy with VBA experience this should be an easy job!
I have to present this code for some co-workers about programming in VBA. Therefore the code must be very flexible and fast, and the use of functions and variables etc. has to be chosen wisely.
Code must serve its purpose, but it's the way the code is written that is important.
The job:
Main part
Make a new excel file and work with data from other files that contains both currency (month) for each year in ten years & clientdata in different exel files for the same time of period.
You will have to make all data connect together and find the total sum of sales (calculated after the correct currentcy) for each year, for a given currency.
Features in the code:
- Write a inputbox that contains the ten biggest clients when writing a correct year as input in a new sheet.
- Write a inputbox that contains a graf (circle) of how much was sold in the different currencies in the specific year(input).
Final code MUST be very organized. I mean with use of "call" etc.
- I have files too 2009 for currency(valuta) and sales(salgsdata)
Thank you!
I've good experience on vb, .net, VBA for excel, word and autocad. I can finish this proj in less than 5 days. Please clarify all your requirements before fix the deal.
I'm open to negotiate based on quantity of work.
Thanks,
Hiren
Hi,
I looked into the attached spreadsheets and I understand the project.
I am very good in writing VBA Programs.
I work on another freelance website.
Please let me know your interest.
Lakshmi.
Hello I'm fairly skilled in Visual basic and excel I've created several reports that require excel calculations and programming calculation.
Atish Dullabh
Hi,
It is quite interesting task. I am interested to handle this Project. I have good Exp in VBA and done lot of Macros (Timeticker, Sending Email, Converting PDF...). Give me a chance to work for you.
Waiting for your approval .
Thanks.
I am a Excel VBA expert developer. I have very good experince with VBA Excel 2007.I have developed addins for excel. I will provide quick & professional service.