basic training excel - Creating a custom filter on separate sheets | Excel forum

Hi Hannah

Thanks for your question.

This may be covered on our Microsoft Excel training courses.

What I would suggest is use the advanced filter and choose the option which allows you to copy the filter results to a specific location. I know this won't allow you to put the copy of the results on a separate sheet, but you could put them on the same sheet as the data, then cut and paste the data to a different sheet afterwards.

Otherwise once you have filtered the data to show what you want, you can create a custom view (View - Custom Views) and 'save' the filtered view by clicking the Add button and giving the view a name. Then you can remove the filter and access the filtered information again quickly by going to View - Custom Views and clicking Show.

I hope this helps.
Amanda