Hello,
I'm new to the forum and asking my first Excel question. I'm trying to create a sorting filter for multiple columns in one area of a spreadsheet and then trying to create a sorting different filter in an unconnected area of the same spreadsheet. When I attempt this I get an error message that says,"The command you chose cannot be performed with multiple sections. Select a single range and click the command again." Is there a way to have different filters in the same sheet?
I have attached the file to provide a clearer example of what I am trying to accomplish.
Thank you for any advice you can give.
Bookmarks