Dears,
this is my first post here, I am looking for a piece of advice. I have an input file produced by the IT. It contains a number of columns. On this file I need to perform a number of different checks - most of the time it's done by applying different sets of filters. Once I applied my filters for check no 1 (so run macro nbr 1) I want to flag (e.g. put 1 as a flag) all hits in a new column (Column1). Ideally give it a name corresponding with that check. Then I would like to reset all the filters and perform check no 2 and flag all the hits in Column2. I would like to repeat that loop for all the checks I have.
In the end I will have a big overview of rows that were hit by each of the check.
That would be all. I know nothing about excel macros, I've just learnt how to run a macro that allows to filter on many attributes but that's all what I know. I assume that the complexity I am asking about comes from (1) the fact that I would like to maintain only one file and (2) that it will require running macros in the loop.
Any advice will be appreciated.
I started learning how to use autofilters based on this tutorial https://www.exceltip.com/vba/vba-cod...lter-data.html.
I can run a very simple one but how I can flag rows hit by check nbr 1? and then move to another check?
Bookmarks