Formula or VBA?

%3CLINGO-SUB%20id%3D%22lingo-sub-3301024%22%20slang%3D%22en-US%22%3EFormula%20or%20VBA%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301024%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20inspection%20report%20that%20is%20quite%20time%20consuming%20to%20fill%20in%20and%20submit%20and%20I%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20set%20up%20a%20%3CU%3Etemplate%3C%2FU%3E%20of%20it%20in%20either%20%3CU%3Eword%3C%2FU%3E%20or%20%3CU%3Eexcel%3C%2FU%3E%20and%20auto%20fill%20it%20with%20specific%20information%20located%20within%20a%20separate%20report%20(in%20word%20format)%20when%20we%20download%20it%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExplanation%3A%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20field%20technicians%20complete%20onsite%20inspections%20%26amp%3B%20testing%20for%20our%20clients%20and%20upload%20the%20results%20to%20a%20web-based%20compliance%20program%20that%20can%20include%20data%20on%20literally%20100ss%20of%20%22devices%22%20for%20any%20particular%20client.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20basic%20information%20for%20our%20clients%2C%20name%2Faddress%2Fphone%20number%2Fcontact%2Fetc...is%20set%20up%20in%20the%20office.%26nbsp%3B%20As%20the%20field%20technicians%20are%20completing%20their%20onsite%20inspections%2C%20they%20fill%20in%20specific%20data%20for%20each%20device%2C%20and%20upload%20their%20report%20for%20client%20access.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20ability%20to%20download%20reports%20in%20word%20format%20and%20am%20looking%20for%20a%20way%20to%20extract%20specific%20data%20from%20them%20and%20auto-populate%20that%20information%20into%20a%20separate%20form%2Ftemplate%20for%20further%20processing%20on%20the%20back%20end.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20word%20document%20we%20download%20contains%20information%20on%20all%20the%20devices%20inspected%20and%20each%20section%20of%20the%20report%20has%20a%20header%20indicating%20the%20type%20of%20devices%2C%20followed%20by%20tables%20that%20contain%20the%20information%20I%20need%20to%20locate%20and%20extract%20into%20a%20template%2C%20see%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20particular%20report%20includes%20tests%20on%208%20different%20devices%20%22backflows%22.%26nbsp%3B%20I%20have%20highlighted%20the%20information%20I%20need%20to%20extract%20for%20the%20first%20device%20only%2C%20as%20an%20example%20of%20what%20information%20is%20needed.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22BFP%20Data_Page_1.jpg%22%20style%3D%22width%3A%20772px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368745i49A934A0CF7E262C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22BFP%20Data_Page_1.jpg%22%20alt%3D%22BFP%20Data_Page_1.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22BFP%20Data_Page_2.jpg%22%20style%3D%22width%3A%20772px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368744iBB0AC63D528FDFA1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22BFP%20Data_Page_2.jpg%22%20alt%3D%22BFP%20Data_Page_2.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22BFP%20Data_Page_4.jpg%22%20style%3D%22width%3A%20772px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368743iACCCD9F5715AC8BE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22BFP%20Data_Page_4.jpg%22%20alt%3D%22BFP%20Data_Page_4.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20I%20can%20give%20additional%20information%20or%20clarifications%20on%20the%20included%20information%20to%20help%20with%20any%20answers%20you%20may%20have%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20any%20help%20you%20are%20able%20to%20offer!%3C%2FP%3E%3CP%3EJoe%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3301024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302146%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20or%20VBA%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1173182%22%20target%3D%22_blank%22%3E%40JStender1994%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F957-excel-link-textbox-to-cell.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20To%20Link%20Textbox%20To%20A%20Specific%20Cell%20In%20Excel%3F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20future%20please%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CP%3EExcel%20version%2C%20operating%20system%20and%20storage%20medium%2C%26nbsp%3Bfile%20(if%20possible)%20or%20a%20photo.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

We have an inspection report that is quite time consuming to fill in and submit and I would like to know if it is possible to set up a template of it in either word or excel and auto fill it with specific information located within a separate report (in word format) when we download it?  

 

Explanation: 

Our field technicians complete onsite inspections & testing for our clients and upload the results to a web-based compliance program that can include data on literally 100ss of "devices" for any particular client. 

The basic information for our clients, name/address/phone number/contact/etc...is set up in the office.  As the field technicians are completing their onsite inspections, they fill in specific data for each device, and upload their report for client access.  

I have the ability to download reports in word format and am looking for a way to extract specific data from them and auto-populate that information into a separate form/template for further processing on the back end.  

The word document we download contains information on all the devices inspected and each section of the report has a header indicating the type of devices, followed by tables that contain the information I need to locate and extract into a template, see below:

 

This particular report includes tests on 8 different devices "backflows".  I have highlighted the information I need to extract for the first device only, as an example of what information is needed.  

 

BFP Data_Page_1.jpg

 

BFP Data_Page_2.jpg

 

BFP Data_Page_4.jpg

 

Please let me know if I can give additional information or clarifications on the included information to help with any answers you may have? 

 

Thank you in advance for any help you are able to offer!

Joe 

1 Reply

@JStender1994 

How To Link Textbox To A Specific Cell In Excel?

 

Hope I could help you with these links.

 

For the future please include the following info to help others answer your question:

Excel version, operating system and storage medium, file (if possible) or a photo.

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)