tommyleinen
Board Regular
- Joined
- Aug 22, 2009
- Messages
- 74
I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'.
What I'd like to achieve is a button that filters to the next one on the list each time it is pressed, once I've marked them as 'done'.
There are many sheets I would like to use this on, so I intend to put this is in my personal macros for use on all sheets of similar makeup. However the position of the header row sometimes varies, from row 5 to row 9, and the headings filters I filter on are usually in columns C, E and column AT, however these too can vary. So ideally, what I'd need is to be able to do is influence the script by changing these parameters if necessary at the beginning of the process (perhaps a different macro that works in tandem).
There are autofilters across all headings on row 8 say, and usually I will filter 2 columns on say E and AT. The filter on E will be set to view all except 'x' (which are the ones I have marked done with an 'x') and AT is set to view all except '-'.
Those two columns have now provided those that I need to check, though sometimes I need to view all on those two and filter from a column from anywhere in between E and AT on the nonblanks - but that is a side issue.
I think the macro needs to first set the two filters and then copy the resultant 'list' of unique values from column C to perhaps a hidden sheet or another sheet, sort the list alphabetically and delete the top value / row each time the button is pressed and it cycles to filter in column C on the main sheet to the next value on the list. It would be ideal if the last value checked is retained on the main sheet above the 'done' column in E6, say.
I can provide a sample sheet using non identifiable data if necessary, any help with this would be much appreciated as it is well out of my league!!
What I'd like to achieve is a button that filters to the next one on the list each time it is pressed, once I've marked them as 'done'.
There are many sheets I would like to use this on, so I intend to put this is in my personal macros for use on all sheets of similar makeup. However the position of the header row sometimes varies, from row 5 to row 9, and the headings filters I filter on are usually in columns C, E and column AT, however these too can vary. So ideally, what I'd need is to be able to do is influence the script by changing these parameters if necessary at the beginning of the process (perhaps a different macro that works in tandem).
There are autofilters across all headings on row 8 say, and usually I will filter 2 columns on say E and AT. The filter on E will be set to view all except 'x' (which are the ones I have marked done with an 'x') and AT is set to view all except '-'.
Those two columns have now provided those that I need to check, though sometimes I need to view all on those two and filter from a column from anywhere in between E and AT on the nonblanks - but that is a side issue.
I think the macro needs to first set the two filters and then copy the resultant 'list' of unique values from column C to perhaps a hidden sheet or another sheet, sort the list alphabetically and delete the top value / row each time the button is pressed and it cycles to filter in column C on the main sheet to the next value on the list. It would be ideal if the last value checked is retained on the main sheet above the 'done' column in E6, say.
I can provide a sample sheet using non identifiable data if necessary, any help with this would be much appreciated as it is well out of my league!!