So I work in a secondary school, as such we're trying to make a temporary register that will auto sort. We therefore have a sheet for each year group. So I need multiple sheets to auto sort based on multiple columns, I've found information on how to do 1 column on multiple sheets or multiple columns on 1 sheet unfortunately I don't understand coding well enough to put these things together. I can manage to alter code to make it match what I'm working with but not stick two bits together.
Can anyone help?
-
Welcome to Web Applications. What do yo mean by coding/code? Does it means writing spreadsheet formulas or writing code in Google Apps Scripts? – Rubén♦ Jan 6 at 2:37
-
I mean writing code in Google apps scripts. – Richard Weatherill Jan 7 at 14:46
-
See this answer to How can I make some data on a Google Sheets auto-sorting? – Rubén♦ Jan 7 at 14:53