Is it possible to specify non contiguous ranges for the data sheet?
I ask because I'd like to have two different views of the same dataset for two different audiences (teachers and their pupils).
I need each view to have different options for the filters, which I don't think can be achieved with two different templates.
I may be able to achieve what I need on a separate sheet using the importrange function, but I'm hoping there is a neater solution available.
View 1 uses columns 1 to 10 and I need to show the filters from columns 1,2,3
View 2 uses columns 1 to 10 and I need to show the filters from columns 4,5,6
Obviously, I'd appreciate your views if I'm looking at this the wrong way and you have a better alternative approach.
Please sign in to leave a comment.