filtering data without view changing for rest of sheet

Hi i would like to know if there is a way of being able to filter the data i have on the left of my worksheet without it hiding the data on the right side of my sheer

Hello SJGidman,

The general answer to your question is "no". However, you could use the Advanced Filter on the same worksheet using a VBA code as follows:-

Please Login or Register  to view this content.

It basically, and very quickly, moves the filtered data over to another part of your worksheet starting at cell N1.
I've attached your sample with the above code implemented and assigned to the blue "Test Me" button.

Place a criteria in, say, Q2 (under "Stationary",e.g Books) and click on the button. You'll see all the required data for "Books" appear from row4 down. You can, of course, use more than one criteria.

Let us know your thoughts on using this method.

I hope that this helps.

Cheerio,
vcoolio.

This seems like a solution i could work in to my sheet, great thanks for the help

You're welcome and thanks for the rep.

Let us know if you need any more help with this.

Cheerio,
vcoolio.