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.
44 freelanceria on tarjonnut keskimäärin 339$ tähän työhön
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.
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.