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

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.

Taidot: Excel, Visual Basic

Näytä lisää: creating word documents excel data, export data range excel workbook, data transfer word documents, client data sheet excel, getting data excel word documents, excel workbook word vba macro, parse word documents excel, client data base excel, formatting excel files word documents, vba open close excel workbook word macro, vba excel headers word documents, work online data entry excel word, attach word documents excel sheets, data entry excel documents, data excel workbook master workbook using vba

About the Employer:
( 0 reviews ) Australia

Projektin tunnus: #13161094

38 freelanceria on tarjonnut keskimäärin 418 $ tähän työhön


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 Lisää

526 $ AUD 5 päivässä
(488 arvostelua)

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 Lisää

400 $ AUD 3 päivässä
(515 arvostelua)

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 Lisää

750 $ AUD 7 päivässä
(191 arvostelua)

Hello, I am ready to collect data from all sheets and make a final worksheet. LET'S DISCUSS before starting the task. I would love to work on this task. I can easily do any task in excel for example, creating m Lisää

300 $ AUD 5 päivässä
(123 arvostelua)

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 Lisää

500 $ AUD 4 päivässä
(85 arvostelua)

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 Lisää

250 $ AUD 2 päivässä
(183 arvostelua)

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 Lisää

400 $ AUD 4 päivässä
(166 arvostelua)

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 Lisää

250 $ AUD 5 päivässä
(141 arvostelua)

Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satis Lisää

250 $ AUD 3 päivässä
(183 arvostelua)

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 3 päivässä
(181 arvostelua)

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 Lisää

250 $ AUD 5 päivässä
(116 arvostelua)

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 Lisää

1578 $ AUD 25 päivässä
(20 arvostelua)

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Lisää

250 $ AUD 10 päivässä
(26 arvostelua)

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 Lisää

500 $ AUD 10 päivässä
(115 arvostelua)

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 Lisää

555 $ AUD 10 päivässä
(56 arvostelua)

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. Lisää

333 $ AUD 3 päivässä
(18 arvostelua)
555 $ AUD 10 päivässä
(63 arvostelua)

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients.

250 $ AUD 3 päivässä
(31 arvostelua)

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 Lisää

300 $ AUD 5 päivässä
(47 arvostelua)

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 Lisää

290 $ AUD 4 päivässä
(26 arvostelua)