question

mequinta-1959 avatar image
0 Votes"
mequinta-1959 asked

How do I sort multiple excel workbooks at once?

Hi,

I have 10+ excel files with same formatting that I need to sort by the first row in ascending order (see example below). Is there a way I can automate this? It's not practical for me to go into every file and sort. I am also not interested in consolidating data into one workbook with several sheets. I need them to stay as separate files. Thanks!

112231-screen-shot-2021-07-06-at-90559-am.png


office-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers