Đã hoàn thành

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

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.

Kĩ năng: Python, Excel Macros, Lập trình C++, Excel VBA

Xem nhiều hơn: excel vba import excel sheet excel sheet, vba thumbnail excel sheet, create stand alone excel sheet, import data from word to excel using vba, excel vba export to word document, how to transfer data from excel to word template using vba, how to transfer data from excel to word using vba, macro to export data from excel to word, vba code to save excel file as word document, populate word document from excel vba, vba code to copy from excel and paste in word table, vba workin excel sheet, vba post excel sheet web, access vba import excel sheet, code create pivot table excel sheet, vba save excel sheet text word doc, create product list excel sheet ```````````````````, create macro pdf excel sheet, create statement cash excel sheet, i am looking to build excel sheet contains multiple sheets

Về Bên Thuê:
( 5 nhận xét ) Longueuil, Canada

ID dự án: #26470503

Được trao cho:

(27 Đánh Giá)
5.6

44 freelancer đang chào giá trung bình $339 cho công việc này

ineedWorkJob

Greetings sir, I have read your project details and i will develop script to collect car data from word files into excel sheet. Sir, i can deliver this project sooner than you expect and will be over your satisfa Thêm

$500 CAD trong 1 ngày
(93 Nhận xét)
6.3
schoudhary1553

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 Thêm

$250 CAD trong 5 ngày
(74 Nhận xét)
6.5
(20 Nhận xét)
5.2
ksriniravi

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 Thêm

$300 CAD trong 5 ngày
(25 Nhận xét)
5.3
Pashakolp31

Hello. My name is Pavel and I’m a Web and Desktop Developer from Russia who is specialized in C#, VBA and PHP. I can do your job using VBA very perfect and quickly. You can see my feedback. Please check the URL. http: Thêm

$350 CAD trong 4 ngày
(14 Nhận xét)
4.8
sourabhg98

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 Thêm

$250 CAD trong 2 ngày
(18 Nhận xét)
4.4
AnowarRatul

----------------✅------------------------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 exc Thêm

$250 CAD trong 2 ngày
(36 Nhận xét)
4.6
mrbrave

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 Thêm

$260 CAD trong 2 ngày
(26 Nhận xét)
4.6
dhanrajkarthick

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 trong 3 ngày
(21 Nhận xét)
4.7
Sercho56

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 i Thêm

$250 CAD trong 3 ngày
(8 Nhận xét)
4.7
qasimalikgmail

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 t Thêm

$300 CAD trong 7 ngày
(15 Nhận xét)
4.5
writingapp

Hi. I have written many automation Excel Word VBA macros. Ready to write your project. Will complete within 2 days

$320 CAD trong 2 ngày
(23 Nhận xét)
4.6
finecodervw

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 helpfu Thêm

$250 CAD trong 4 ngày
(5 Nhận xét)
3.9
Demenntor

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 a Thêm

$550 CAD trong 3 ngày
(18 Nhận xét)
3.9
emilianoreyes70

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 Thêm

$260 CAD trong 7 ngày
(5 Nhận xét)
3.6
greatswork

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, CodeIg Thêm

$500 CAD trong 3 ngày
(5 Nhận xét)
3.3
bhupendrayadav

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 consulta Thêm

$700 CAD trong 5 ngày
(4 Nhận xét)
3.5
narsim3128

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. Thêm

$250 CAD trong 3 ngày
(2 Nhận xét)
3.1
(3 Nhận xét)
2.8
dheerajjshetty19

Hello! Am very interested in ur project and I am an expert in Finance/Accounts/Payroll/SAP/Bookkeeping/Excel/VBA/Marcos/Quickbook.I can meet all requirement of the project. Please Ping me for further discussion.

$250 CAD trong 1 ngày
(2 Nhận xét)
2.3