I am trying to extract some specific data from multiple excel files. All of the excel files are standard. But in some excel files, the place of the requested cells are changing.
What I would like to extract from the excel files:
1 - Name of the Excel File
2 - Date
3 - Invoice Number
4 - Total Amount of the Invoice
Because the location of the requested cells are changing, i think I need to find the “Date” or “Total Amount” words and export them to another data table.
Any advice how to do this correctly?