I have an excel file on a website. This excel file has auto filter on all columns. I need to provide data to users with different filters turned on (lot of different combinations of filters). Is it possible that when a user clicks on a link on the website, before opening that excel file, a macro or some script runs so that data is filtered depending on which link user clicked?
Or is there any other way to do it (other than creating copies of excel file, saving it with the filters that I need and then linking individual links to those different files with different filters turned on)?
Thanks,
Sanjay
Bookmarks