Find Jobs
Hire Freelancers

Build an Excel workbook to consolidate client data, produce word documents and calculations

$250-750 AUD

Closed
Posted about 7 years ago

$250-750 AUD

Paid on delivery
I have a basic excel workbook which has multiple worksheets where some data from each worksheet is required to be collated on a final worksheet and then produce multiple letters and mapping the data into the word documents. We need to collect client data. From that data, we use an alternate system to select a clients required product and paste the data into a worksheet. Then we need to bring some of that data into two/three different documets to present to the client. I would like to streamline this process to save as much time as possible. Limit re-work and flipping back and forth between worksheets as much as possible. We will also require most of this data to be collated in a specific format as it will need to be manually input into a third system.
Project ID: 13161094

About the project

36 proposals
Remote project
Active 7 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
36 freelancers are bidding on average $427 AUD for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$526 AUD in 5 days
5.0 (872 reviews)
9.3
9.3
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 AUD in 2 days
4.9 (532 reviews)
8.4
8.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$250 AUD in 5 days
5.0 (555 reviews)
8.5
8.5
User Avatar
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$400 AUD in 3 days
5.0 (1189 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$300 AUD in 3 days
5.0 (495 reviews)
8.0
8.0
User Avatar
Hi, I am an Excel data automation expert and would be happy to assist you. After collating the data in Excel file, I can create an Excel macro to generate the required output in PDF file. Kindly confirm the Excel version in use. Regards, Arul
$750 AUD in 7 days
5.0 (202 reviews)
7.4
7.4
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
$1,578 AUD in 25 days
5.0 (32 reviews)
7.1
7.1
User Avatar
Hello, I am among the highest rated Excel and VBA freelancers and I can automate the Excel operations such that you shall not need to flip back and forth and all the work shall be done on the click of a button. I have done many similar projects before and I can do it within a couple of days. Please discuss over chat. Thank you, Usman
$500 AUD in 4 days
5.0 (92 reviews)
7.1
7.1
User Avatar
It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in JAVA, C++, C#, OPPs, HTML5, CSS3, JS, AJAX, JQYERY, React.js, ANGULAR.JS, BACKBONE.JS, BOOTSTRAP, PHP,Wordpress, ASP.NET, MVC, Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great results.I have fast internet connection at home, have my own pc to use anytime and have own space to work. I can work fulltime and will focus to this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. Thanks and more power. MOHSAN IJAZ
$555 AUD in 10 days
5.0 (99 reviews)
6.8
6.8
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$400 AUD in 4 days
4.8 (194 reviews)
7.2
7.2
User Avatar
Hi: I understand that you want to automate a process involving Excel and Word Document. The data from multiple Excel tabs is populated into a master sheet. From here, it is mapped to a few Word documents that you share with your client. Please confirm if my understanding is aligned with your requirement. Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects. Please connect with me to discuss your requirements in detail.
$250 AUD in 5 days
4.9 (171 reviews)
7.1
7.1
User Avatar
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients.
$250 AUD in 3 days
5.0 (48 reviews)
6.6
6.6
User Avatar
HI, I could add a button in the task bar of your MS Excel to run the macro that will create a last tab collection the data you want, but i will need more details about which data to collect and the format it should have.
$290 AUD in 4 days
5.0 (57 reviews)
6.4
6.4
User Avatar
I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html
$500 AUD in 10 days
4.9 (52 reviews)
6.3
6.3
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 AUD in 10 days
4.9 (120 reviews)
6.3
6.3
User Avatar
Hello Sir/ Madam Greetings, It is my great honor to apply for this job vacancy. I am very hard worker and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research, Web scrapping by Program and Microsoft Office. Product upload to E-Commerce, Woo Commerce, Amazon, eBay. Also work as Virtual Assistant. I can work full time and will focus on this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. Regards Tanveer Hasan
$300 AUD in 5 days
5.0 (72 reviews)
5.9
5.9
User Avatar
Hello I'm interesting your project very well I'm a Good VBA, Excel, Java, Db, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks
$333 AUD in 3 days
5.0 (19 reviews)
6.0
6.0
User Avatar
Hi, Experienced Excel Macro Developer. I have read your instructions carefully and saw attached excel file. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets and Creating Consolidated Reports or Combined the data into single Sheet. I also have experience of manipulating Word Document and share excel data to word document. I have created Mail Merge function in Excel VBA Program so you can use if you needed. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 AUD in 3 days
4.8 (136 reviews)
6.2
6.2
User Avatar
I have experience in Excel, VBA, Macros, Charts and integration with PowerPoint, Word from VBA and have completed some projects requiring producing documents in Powerpoint and Word from Excel data. PM for more discussions on your requirements.
$250 AUD in 5 days
4.9 (70 reviews)
5.8
5.8
User Avatar
Hi, I am a native Australian finance professional (based in Melbourne) with over 15 years experience using Excel to build a variety of different models, including ones used for forms, databases and financial reporting. I would propose to complete your project by helping to set up formulas across the different sheets to pull the same information - i.e. customer information, loan values etc. For example, I would suggest pulling the customer information from the CNA sheet onto the other sheets (or please let me know if there is another sheet that is better to pull this information from). Likewise, I would suggest pulling the loan amount and details from the "Funds table" sheet - or another sheet if you advise that there is one more suitable. I would work with you to understand the flow of data that you work with and help to ensure that as much of the worksheet could be automated as possible. I welcome the opportunity to discuss your project further and to work with you. Thanks & regards Melanie
$300 AUD in 10 days
5.0 (12 reviews)
4.3
4.3

About the client

Flag of AUSTRALIA
Lane Cove, Australia
0.0
0
Payment method verified
Member since Feb 19, 2017

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.