Hey Everyone,
I have a scenario where I need to apply filter (AX column equals "Business") on an excel file (.xlsb) placed in one drive and copy this data and generate a new file with .xlsx format and paste the filtered data in this xlsx file.
Please let me know how can i achieve this. The filtered data can be as large as 10K row and columns can go upto BO column.
Thanks
Neeraj