I am looking to extract data from completed inspection and Audit log sheets located within a specific folder on my desktop called "Inspections and Audit" into an excel spreadsheet
The Inspection Form has 10 Questions - and the answers data will need to be transferred into a Spreadsheet that has 10 columns
each new completed form should produce a new line
I want the spreadsheet to extract data directly from the word documents within the folder, without opening the individual forms by clicking a button within the provided spreadsheet.
The spreadsheet and word template are attached. Its the coding to make it automatic that is required
20 freelancers are bidding on average $22 for this job
I can do your project using EXCEL VBA. Relevant Skills and Experience Data Entry, Data Processing, Excel, PHP, Visual Basic Proposed Milestones $25 USD - full
I can do this job for you and will try to automate your process so next time you can do it yourself. Relevant Skills and Experience Advance excel, process automation, business intelligence