I got a huge data list with column headers. And now I would like to perform the following tasks using a VBA macro:
The macro is to step to all the data records (row by row) and ...
check whether there are data records which have got the value '99' in Column C and 'not available' in Column G. In these cases the macro is to enter the value 'to be reviewed' in Column 'H' for that data record. Column H is a blank column
I know I could perform this action by using filtering but I wonder how the VBA solution would look like.
thank you very much in advance for your professional support.