I have a table on an audits tab created using the filter() formula so that it pulls data from a master list sheet. I want to be able to sort the data on the audits sheet without using formulas, instead using the common filter dropdown. I've tried to do this and get the error " can't change part of an array", so I'm looking for a way to achieve this purpose. I tried advanced filter and VBA so that whenever the master list changes, I can refresh the audits sheet to reflect the changes but that doesn't work either. Is there a way to do this and still be able to sort the audits sheet results?