Jul 23 2021 09:10 AM
Hi,
I need to complete a manually intensive taks which requires me to manually copy information from a word document for it to be viewed and analised in excel.
Attached a sample of the word document with the headers and table data I'm extracting and an example of what this should look like in excel when extracted.
Is there a recommended method for extracting the data and headings into a template sheet with my desired format as shown in the sample?
At the moment I can copy all data from word into an excel sheet which I have added into the excel sample. But can i then automate the building of the template format based on the data I have pasted in?
Thanks in advance.
Jul 23 2021 06:41 PM