Excel file on web with filters
 

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


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=504610