I have a document with multiple sheets that contain similarly formatted data. I would like to sort the data on each page in the same way. In other words, I want to apply a sort to a batch of sheets in a document rather than entering the same sort criteria for each sheet individually. Does anyone know of a way to do such a thing?
For the best of my understanding you would need to write a macro. However, be careful and first test if the sort criteria are matching all of your data sets.