I've been handed an Excel spreadsheet with almost 80 unique fields, which filter out into nine separate tabs - with different sets of columns and filtered data. I'm comfortable creating code to filter out the various reports from a central spreadsheet with all the data.
Now I've been asked to...