Find Jobs
Hire Freelancers

Create a VBA to complete an excel data sheet from data contained in multiple word files -- 2

$250-750 CAD

已完成
已发布将近 4 年前

$250-750 CAD

货到付款
So we need to create an excel data sheet for all vehicle’s year, make and model from 2004 up to 2020. All information is contained into multiple Word .DOC. Each car year, make and model is one .doc file. On Excel collumns looks like that Collumn A Collumn B Collumn C Collumn D , Collumn E …. All other collumns Filename Folder path Year Make Model …. Data attribute name as written in all .doc files. If there is no value found in word, just leave empty and go to the next. Operation would be like: Lookup F4 value into B5 (filepath -- .doc), get the F4 attribute value up to the system find any other attribute name contained in F4 up to GT4. Basically, it is a kind of Vlookup from Excel to Word with rule that will stop getting attribute value when it finds another attribute name.
项目 ID: 26470503

关于此项目

41提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
$0 CAD 在3天之内
4.9 (45条评论)
6.2
6.2
41威客以平均价$339 CAD来参与此工作竞价
用户头像
Hi, Greetings! ✅checked your project details: Create a VBA to complete an excel data sheet from data contained in multiple word files ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$250 CAD 在5天之内
4.9 (105条评论)
6.9
6.9
用户头像
----------------✅------------------------I CAN START RIGHT AWAY----------------✅------------------ Hello sir, I have read your project details carefully and understand it clearly. I can Create a VBA to complete an excel data sheet from data contained in multiple word files maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain
$250 CAD 在2天之内
4.9 (92条评论)
5.4
5.4
用户头像
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I can develop an Excel Macro that would look into all WORD documents in a folder and update the Attribute values from information in WORD document. Please share the Excel file format as well as couple of sample WORD files - I would come up with a solution as required. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$300 CAD 在5天之内
5.0 (26条评论)
5.4
5.4
用户头像
Hello, I am an Australian-based software developer with significant experience in coding text parsing algorithms in VBA. I have experience in working with both Excel and Word and imagine that you have a word-doc that is basically formatted in some structured data format (like JSON, XML, HTML, or similar) and you want to have a function that will search the File name entered for the data 'header' (also known as title/label/key) and return the data 'value' to the Excel spreadsheet. I'll be easily able to implement the above using a VBA code that will be called to get the outcome. To write this, I will need a copy of your excel file and at least 2-3 examples of the word documents. If you want to ask any questions, please feel free to reach out via Private Message.
$250 CAD 在3天之内
5.0 (17条评论)
5.3
5.3
用户头像
Hi there, Gone through your requirements and yes it can be done. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response to get started immediately. Regards, Karthick G.
$250 CAD 在3天之内
5.0 (36条评论)
5.2
5.2
用户头像
Hi, I have completed 250+ Excel VBA related projects here. I have couple of questions, before starting. Are all documents in same format? or they are different? If not difference is how much? You want the script for one time process only or you will use that in future too with other documents? I am asking because, you may have different format document in future. Lets discuss these point and get started quickly. Thanks
$260 CAD 在2天之内
5.0 (37条评论)
4.8
4.8
用户头像
Hi. I have written many automation Excel Word VBA macros. Ready to write your project. Will complete within 2 days
$320 CAD 在2天之内
4.9 (45条评论)
5.1
5.1
用户头像
Hello, I am expert in VBA and database management, I can using VBA to get Word document data(Vehicle year, model...) and add it to one Excel file and they will aligned by specified relationships. I am good in C#, VB, VBA for 6 years and I made Excel VBA dashboard and integrated some APIs, VBA scrapping. Please contact to me and I will finish your project in 3 days. Thank you. Ruslan.
$250 CAD 在3天之内
5.0 (3条评论)
4.8
4.8
用户头像
Hello, I have expertise in writing VBA macros for EXCEL and can write one for this task. The macro will open word files, one by one, extract the desired info about the vehicle and put it in an excel sheet. Since this task might take some time, so the progress will also be shown so that you can get the feedback about the current status. Looking Forward
$300 CAD 在7天之内
5.0 (18条评论)
4.7
4.7
用户头像
Hi, As I understand you need to complete Excel file by looking into MS Word file for matching values. It would help if you can please share sample MS Word file as well as Excel sheet. A quick discussion will be helpful. Keen to work on this. I am well versed with MS Word object mode and understand how to read various tables and sections in MS Word, at the same time I am equally comfortable with Excel macro. I will be happy to answer any queries you might have. Looking forward to your response. Thanks
$250 CAD 在4天之内
5.0 (12条评论)
4.8
4.8
用户头像
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I can easily scrape all the data from the word files to an excel sheet in the desired format. Could you please share a sample of the word doc for one vehicle so I can understand the requirements better? I look forward to a positive and prompt response from your side. Regards Sourabh
$250 CAD 在2天之内
5.0 (22条评论)
4.5
4.5
用户头像
Dear Employer, I have read the project details and confident to work on create a vba to complete an excel data sheet form data contained in multiple word files. I have extensive knowledge on Python, C++ Programming and Excel VBA. Kindly message me so that we can discuss more about the work. Regards Lucky
$550 CAD 在3天之内
5.0 (21条评论)
3.9
3.9
用户头像
HI! I am an engIneer and Excel/VBA/Macro expert and Google Scrpit , Google Sheets expert too. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). REgrads, Juan
$260 CAD 在7天之内
5.0 (8条评论)
4.0
4.0
用户头像
Okay, I'll create an excel data sheet for all vehicle’s year, make and model from 2004 up to 2020. Can you pls. share with me 1 or 2 .docx files. Just for basic understanding. You can ping me..................thanks
$500 CAD 在7天之内
5.0 (10条评论)
3.7
3.7
用户头像
I am a full time freelancer providing automation consultancy to SME / MSME companies . Please find below a brief introduction of myself. I am postgraduate having more than 7 years of experience in automation consultancy, advanced excel based tools, Excel-Word-PPT automation integration, VBA automation, dynamic dashboards, google spreadsheets, google scripting, and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel-Word-PPT integration based automation tools for Ernst & Young and Landmark Group also. You can get your work done here with highest quality at lowest price . Please initiate a chat so we can discuss on this as I may have some questions. Looking forward to work with you
$700 CAD 在5天之内
4.6 (6条评论)
3.9
3.9
用户头像
I have high specialization and experience in the Development of Desktop, Web and Mobile Applications. Programming languages: C, C++, C#, Python, GO, Matlab, Java, VB, kotlin, JavaScript. Web Framework: Django, CodeIgniter, Laravel, CAKEPHP, Yii. Web Development: Front-End, Back-End and Mobile Applications: - PHP, Aspx NET CORE, asp, HTML5, JSON, XML. - Node.js, Angular, React, JavaScript, Jquery, Ajax, REST, SOAP - CSS3, Bootstrap, Less, Sass, Scss, Responsive, Material. Mobile applications: Xamarin, Flutter, React, Swift. I work in the IDE: Visual Studio 2019, VSCode, Eclipse, Idle, phpstorm, GOland, I am a specialized expert. I have 10 years of experience. Please check my independent profile. I can also send samples of my work by chat. can i start right away Best regards
$500 CAD 在3天之内
4.9 (5条评论)
3.3
3.3
用户头像
Hello, how are you ?, I'm Pedro, I have just read your project about creating a Macro that completes an Excel file from several Word documents, the first requirement being to search for vehicle data in column order, with the exception of failing to search, leave the line blank and go to the next line. Do you need the Macro to be activated as a complement in the Excel quick start menu or with a button in the Excel sheet? And do you want me to ask you where the folder of the Word files will be or do you want to predetermine it in the code? Well, I can offer since I have experience in this type of tasks and to have a better detail of what is requested we can talk in the chat and clarify the doubts and thus I will know more accurately when I can have them ready. I understand that this project is important to you and my true interest is to do a good job with efficiency and effectiveness. Best regards Pedro Requena
$450 CAD 在10天之内
5.0 (1条评论)
3.1
3.1
用户头像
Hi there, I am an expert in excel formulas, dashboards, macros. I have gone through the description on your project and will be able to finish before the deadline. Thanks Jayant
$250 CAD 在7天之内
4.6 (5条评论)
2.9
2.9
用户头像
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME MY QUOTE FOR THIS TASK IS $200 CAD With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, excel macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$250 CAD 在3天之内
3.7 (5条评论)
3.8
3.8
用户头像
Hello there! Your project looks interesting as I am a big car fan! I have done similar projects to this with reading in word documents and combining them. If I understand the requirements correctly, I believe that I can have this done for you with a beautiful GUI display. Thanks, Caleb
$400 CAD 在7天之内
5.0 (3条评论)
2.3
2.3

关于客户

CANADA的国旗
longueuil, Canada
5.0
9
会员自2月 27, 2020起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。