$80 from excel open word, read each line and copy data into excel

  • Hi
    - from excel I would like to open source.docx, and read each line in that file
    - depending on the criteria , see : sheet criteria in the destination.xlsx file, data would be passed to excel into columns
    - the output sheet in destination.xlsx shows an example of how the file would look like
    ------------------
    if needed I will send a function that removes portuguese special characters so that the string search can be done properly
    -----------------

  • It might be useful to have the function for removing Portuguese special characters

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.