Suljettu

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ää: client data sheet excel, client data base excel

About the Employer:
( 0 reviews ) Australia

Projektin tunnus: #13161094

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

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

526 $ AUD 5 päivässä
(488 arvostelua)
8.0
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 Lisää

400 $ AUD 3 päivässä
(515 arvostelua)
7.5
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 Lisää

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

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

500 $ AUD 4 päivässä
(85 arvostelua)
6.9
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 Lisää

250 $ AUD 2 päivässä
(183 arvostelua)
6.9
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 Lisää

400 $ AUD 4 päivässä
(166 arvostelua)
7.0
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 Lisää

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

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

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

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

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

500 $ AUD 10 päivässä
(115 arvostelua)
6.3
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 Lisää

555 $ AUD 10 päivässä
(56 arvostelua)
5.6
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. Lisää

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

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

300 $ AUD 5 päivässä
(47 arvostelua)
5.5
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 Lisää

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