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

Closed Posted 7 years ago Paid on delivery
Closed 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.

Excel Visual Basic

Project ID: #13161094

About the project

36 proposals Remote project Active 6 years ago

36 freelancers are bidding on average $427 for this job

jaylancer43

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 More

$526 AUD in 5 days
(872 Reviews)
9.3
schoudhary1553

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 ex More

$250 AUD in 2 days
(532 Reviews)
8.4
ParisPallas

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 y More

$250 AUD in 5 days
(555 Reviews)
8.5
cgullapalli

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 f More

$400 AUD in 3 days
(1189 Reviews)
8.4
P0L

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
(495 Reviews)
8.0
deepbluetech

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 ver More

$750 AUD in 7 days
(202 Reviews)
7.4
esalem

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 More

$1578 AUD in 25 days
(32 Reviews)
7.1
maverick44000

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 ha More

$500 AUD in 4 days
(92 Reviews)
7.1
MohsanEijaz

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, B More

$555 AUD in 10 days
(99 Reviews)
6.8
cugamelover

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 scri More

$400 AUD in 4 days
(194 Reviews)
7.2
aarifakhtar

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 More

$250 AUD in 5 days
(171 Reviews)
7.1
axiomswb

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
(48 Reviews)
6.6
diorisaguilar

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 hav More

$290 AUD in 4 days
(57 Reviews)
6.4
KavTan

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
(52 Reviews)
6.3
dpune

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. Plea More

$500 AUD in 10 days
(120 Reviews)
6.3
adataprocessor

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 More

$300 AUD in 5 days
(72 Reviews)
5.9
Yknox

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. More

$333 AUD in 3 days
(19 Reviews)
6.0
vsprybhanu

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 Co More

$250 AUD in 3 days
(136 Reviews)
6.2
gr8tech

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 discussi More

$250 AUD in 5 days
(70 Reviews)
5.8
telfordm

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. More

$300 AUD in 10 days
(12 Reviews)
4.3