Excel VBA Expert to create a few macros + Dashboard for Cube in Qlikview

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I have a small company with a lot of clients and different projects.

I need someone to create a very complex macro that will bind together all the files with all the clients and all the projects I have and create a Main Excel file with costs for each year and to make it all automated when I push a refresh button.

I also want to be able to send this file via email and FTP, with another button.

From the FTP server I want to take all these files and place them into a Qlikview cube, so I need someone to write the Load Script and do some transformations on the data.

With all the data loaded I need a few dashboards and other Reports.

I would also want to be able to export these reports and send them via email or to another FTP.

I know it's a lot of work for this budget but whoever wins the bid will definitely get more projects from me with bigger budgets. Take this as a test for a job interview.

I will provide more details later in the process.

Data Entry Data Processing Excel QlikView Visual Basic

Project ID: #11510704

About the project

8 proposals Remote project Active 7 years ago

Awarded to:

sergiubutnaru

Hi, I work as a BI Dev and your project sounds very interesting. I would like to help you. Wish you a great day! Sergiu

$10 USD in 1 day
(1 Review)
0.0

8 freelancers are bidding on average $45 for this job

ksriniravi

Greetings Hiring Manager! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation / dashboard reports for Management Reporting. In fact, over the More

$30 USD in 2 days
(85 Reviews)
6.0
nagrahari

Hi , I am an Engineer with 8 years or experience. And from last 8 years I am also working on Data Entry/ Excel. I feel I can call myself as an expert in Copy Typing/Data Entry/ Excel. I have created many Macros f More

$88 USD in 1 day
(3 Reviews)
2.0
EngSh

Hi, I have created complex excel Macro with VB before. Some of the things I have done includes file interaction - extracting information to excel, combine & process data from multiple sheets for reports, forms (butt More

$25 USD in 1 day
(0 Reviews)
0.0
Femiabi

Hi there, I am confident; I can take up your project and do it with perfection. I have excellent communication skills with over 10 years experience in data entry. I can use ms-excel spreadsheet to compute any type More

$30 USD in 1 day
(0 Reviews)
0.0