How to get partial text from .txt file? And after writing to Excel relative cell, data comparison1

Test file download

please everyone

  1. I have a file which can contain any number of lines in a text file. I need to extract “Net Sales - Taxable 57” from a file, especially the “57” count in the file.
  2. Extract Net Sales - Tax Exempt, Net Sales - Total, 2. Other Income, Net… Write to EXCEL (B21:O28).
  3. Compare EXCEL data (B12:O19).
  4. The same display Y, different display N

Hey @adoration50

Is your keyword

always the same ?

If yes then we can go with regex approach !

Thanks
#nK

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.