Shortcut/Macro to tick next entry in auto-filter list with multiple filters being used

Hi JBeaucaire, I really appreciate the reply. I have arthritis so find my hand hurts after repeatedly ticking and unticking these filters! Sometimes I wish it would respond to voice! But until then, your macro is the best thing I've found it can be modified!

I may be mistaken but I thought that your code used column AA as a temporary spot to place data in order for the macro to function.

I don't understand the macro so I'm sorry if I gave you a red herring. BZ isn't important to me as there will never be any data sitting out there

I have filters across all columns, but when using this macro I will be manually setting the filters in E and AI, before I work through each individual tick box in C. So I would like the macro to leave E and AI on the filter they happen to be on at the time (these filter settings could vary), whilst cycling through the filters in column C at each press of the button. The 'show all' button would be useful if it leaves E and AI set but shows all of Col C.

To complicate matters, it may not necessarrily be E and AI that are the 2 filters in operation as well as it can vary. If that makes a solution unworkable then I will look to find a way of standardising the sheet I am working on as a workaround so that your macro can be used.

Thanks again for your help,

T

Originally Posted by JBeaucaire

I don't have a ready solution for this. My method of collecting the values in column C to use as a list using AdvancedFilter instantly removes the current Autofilter settings completely on the entire sheet. My original solution isn't compatible with preserving any other previously applied filters.

I'll tug some other sleeves to see if anyone else has any quick ideas.

Thank you, that's very kind. I've been trying to think of ways myself but all roads lead back to those 2 other filters I need to use!

Originally Posted by JBeaucaire

I don't have a ready solution for this. My method of collecting the values in column C to use as a list using AdvancedFilter instantly removes the current Autofilter settings completely on the entire sheet. My original solution isn't compatible with preserving any other previously applied filters.

I'll tug some other sleeves to see if anyone else has any quick ideas.

What if I standardised the sheet so that we knew which specific columns had a filter on and what they were set to? The column two to the right of the main filter is always set to view all except 'x'. The others being visible are always 'y', blanks, and a heading, usually 'hide'. I could standardise 'hide' too so that it is always that.

I use that column to put a cross in the rows I've checked and so when the next description is selected, the last ones checked disappear from view.

Finally the far most right column, lets say col AT, is always filtered to view the header 'checker', cell value 'check' and blanks. Unticked is always cell value hyphen '-'.

With the macro first removing all filters before it does its work, would it be possible to add a step to apply the other two filters in the other specified columns in the same step as the main filter is being applied?

Thanks