every week we get a big excel file. We import all values into NAV with excel buffer and process the data. Unfortunately the excel file has a filter.
For example: The excel file has 1000 lines and 200 are in the current filter. We want to import only the 200 lines in the filter.
We get the file with the filter and the sender will not change the excel file.
Is there any chance to automate this process? At the moment we copy the filtered lines to a new sheet and import this sheet.