Sort table on inactive sheet

[Sthlm]

I've been working with a script for years, but due to some changes it now also needs to work when the sheet is inactive.

Please Login or Register  to view this content.

Any ideas?

[rorya]

Try this:

Please Login or Register  to view this content.

[Sthlm]

It doesn't have the desired effect. In the sort column there are 'yes' and 'no' values which changed based on info from a different sheet. When changed the input the value does change as expected in the table. But it doesn't sort the table. Only when I manually change a value in the table directly it does the sort as expected.

[rorya]

I don't follow. That code has to be triggered by you, so it's not going to care how/whether you change anything.