Ask Your Question
0

Calc - apply same sort criteria to multiple sheets [closed]

asked 2014-01-02 21:36:33 +0100

Masadaralas gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 10:30:44.475916

1 Answer

Sort by » oldest newest most voted
0

answered 2014-01-03 03:46:19 +0100

ROSt52 gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-02 21:36:33 +0100

Seen: 81 times

Last updated: Jan 03 '14