Find Jobs
Hire Freelancers

Do some Excel Work

$15-25 USD / hour

Completed
Posted about 10 years ago

$15-25 USD / hour

I am looking for a very experienced Excel expert and VBA programmer with whom I would love to have a continuing working relationship. Please find details of the project below. SCENARIO XYZ company with a Headquarter (HQ) and 8 branches currently sends a cash-flow template which it designed in Microsoft Excel to the branches to be filled and sent back to the Headquarters. The branches fill the cash-flow template and send it back to the HQ. The HQ has a master workbook containing worksheets for each branch and another worksheet where all the information is consolidated. XYZ company is concerned about data integrity and security of its current method of sending/receiving and collating the data. WHAT WE WANT XYZ company wants an automated and secure process of collating and consolidating the data sent in by the branches into one master excel workbook. A break-down of the new system is as follows: 1. The branch is sent a workbook containing two worksheets. Worksheet one contains the controls/parameters and worksheet two contains the cash-flow template 2. The branch fills the cashflow template on worksheet two. From workbook one, the branch can select the year and month (to reference a particular cell range e.g cashflow for Jan2014) and then clicks on a button to export the data in XML format. 3. The XML file is sent to the HQ and will be imported to the corresponding worksheet in the master workbook. The master workbook (for use by the HQ) will also contain a worksheet one for control/parameters. User will be able to sect branch (refrencing a worksheet), year and month. It will have a button for import XML which when pressed will import the XML file into the appropriate worksheet and cell range. 4. The cells of past months should be automatically locked so that the data can't be manipulated. Please feel free to suggest alternative and better ways achieve what is described above. The developer will be provided with a sample of the master workbook, the template information that is required to accomplish this project. Compatibility: Microsoft Excel 2003 and above, Windows XP and above
Project ID: 5446458

About the project

24 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello darolutionsl :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed ANYONE TILL date. I have done more than 130 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Please note that there are lot of time wasters here. If you do plan to select me then I would request you to please explain or give me a sample so that I can give you a demo which will ensure that your time and my time is not wasted.. :) Instead of XML, I am planning to encrypt the data and store that data in Excel itself. Hope to work with you. Regards Sid
$22 USD in 10 days
4.9 (153 reviews)
6.5
6.5
24 freelancers are bidding on average $20 USD/hour for this job
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$15 USD in 3 days
4.9 (177 reviews)
6.5
6.5
User Avatar
Hello, I am very good in Excel, Macros and VBA programming. I can complete this task without any error or problem. Let me know if you are interested. Thanks
$20 USD in 3 days
5.0 (103 reviews)
6.1
6.1
User Avatar
Good day, I am excel developer of spreadsheetweb.com. We already thought about this problem and provided best solution for it, you may sign_in as a free trial membership and try it for a month. All it does is converting your excel file to a webpage format and then you may send the webpage address to each brunch. they will fill the online form and press save button, at last you may download all forms field by all brunches in one excel file exactly like what they filled and in your desire format and sequence. Please message me if you need any samples. Best regards. Siroos.
$22 USD in 5 days
5.0 (71 reviews)
6.0
6.0
User Avatar
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 excel. I have successfully completed similar projects for many clients. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas
$24 USD in 10 days
4.9 (39 reviews)
5.6
5.6
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
4.9 (26 reviews)
5.8
5.8
User Avatar
Hi I can help you with your project , I am an excel_vba expert pm me ...................................................................... ........................................................
$16 USD in 25 days
5.0 (37 reviews)
5.3
5.3
User Avatar
Thank you for posting this project and detailing it to a fair level of understanding. I can have your complete requirement encapsulated into a robust com addin for Excel. In this approach I am going to use VSTO (Visual studio tools for office) to create a com addin that is visually appealing, robust, powerful in terms of features and flexible as well as extremely secure as the code is encapsulated and cannot be exposed or de-compliled easily. I will deploy the code as an installer file, which can be very easily installed on the required computers with a few clicks. Once installed, the addin will integrate itself with the Excel version that is installed. It will also detect the version of Excel (2003/2007/2010/2013) as well as the bitness (32/ 64 bit) and accordingly suit itself to load on the target machine. I will completely automate the consolidation process and would even improvise it further to best suit your business logic. My application will be visually appealing as it would not be relying on the traditional VBA controls. To get a feel what I can do for you in this addin, I would request that you visit my portfolio which showcases a recent TOC addin that I developed for MS Excel. By way of introduction, I am a Microsoft certified trainer and application automation specialist for MS Excel (MCP Id: 7531519) with over 9 years of experience delivering trainings and automation solutions to corporates.
$20 USD in 25 days
5.0 (7 reviews)
2.6
2.6
User Avatar
Hi I have worked on many Excel VBA Projects from simple to complex. I have also completed a Project for a Fortune 500 company - Emerson. Here at freelancer.com, I have successfully completed 3 projects. I love to work on challenging projects. I read you Project description, I would like to work on it and complete it as mentioned. I am eager to discuss the project and also I have got few suggestions. Let me know if your interested form my proposal. Looking forward to hear from you. Thanks.
$15 USD in 5 days
5.0 (3 reviews)
2.2
2.2
User Avatar
A proposal has not yet been provided
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
paso muchas horas en el computador es algo que e gusta y no me cansa ,soy aplicada y puedo trabajar en diferentes horarios
$22 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello from Morocco I m Tarik a web developer & IT software programmer please contact me if you want really to accomplish your project
$15 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am flexible and provide cost-effective automation programs. I offer dynamic solutions and will provide follow-up support for glitches and minor changes for free. I strive to maintain long lasting relationships with my clients by providing superior service. Please let me know if you have any questions. Thank you for considering my proposal. Brett
$20 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have read the project description thoroughly. Thanks for providing the detailed information about the project. My profile - I am an experienced software professional with 12 years of experience. Having been a developer and later a manager with software development company, I can develop logic blocks, macros and also easily manage excel sheets. I have taken a break from my permanent job to start off freelancing. I am eager to do work beyond the mundane php/mysql. I will be glad to do this project. Please consider. Regards
$15 USD in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have strong technical background of almost 7+ years where in I have worked in VB Technologies also. Would love to take the task.
$22 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Предложение еще не подано
$22 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi This is Sagar. I am having around 6 year exp in VB6 , VBA and excel macro. Worked on XML queries XML import and export also. Done this type of project. So will finish with accuracy and in time. I am currently online and will start your work immediately. please message me so we can discuss technical things.
$17 USD in 3 days
0.0 (0 reviews)
1.3
1.3
User Avatar
Dear sir, I'm happy to work with you I have experience in writing VBA, extract data from the excel file. I've made a few scripts like: create source code from the specification file, the file search word comment .... I found this job is right for me.
$15 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Lagos, Nigeria
5.0
8
Payment method verified
Member since Oct 19, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.