I'd like to add on to my sub by adding a filter to A6:G6 (first it should clear all filters currently applied, if any)
After that, I would like to filter out all the #N/A in the C and D columns then enter the value 'TEST' in all of the F column.
Then display everything but the #N/A values (once again, C/D columns).
In the future, should I simply record a macro and see what happens, or is it safer to simply ask here? I figure there will be more efficient answers posted here. Unfortunately, I know next to nothing about macros, still learning.
I'd also like to combine it with this macro I currently have (which should be run last) feel free to improve upon it if you see fit:
Thanks, as always, in advance. Love how helpful everyone is.![]()
Please Login or Register to view this content.
Bookmarks