Reset filters back to default

[Joey7]

Hi all, first time poster here.

I have a spreadsheet with 3 different users and a "Sheet View" has been created for each of them. Each view has different filters applied based on what is relevant to the user.

They are able to go in and change the filters as they please, which is necessary to keep. Is there any way to create a macro button they can click that resets the filters back to how I initially had them (default)?

Thanks!
Joey

 

[Joe4]

Welcome to the Board!

This probably can be done, though it would be most helpful if we could see a small sample of your data and the original filters you want to go back to.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.