Hi macropod,
If I make it 30, it's possible that some of data below Red won't be removed. Sometimes Red has 3 rows below and sometimes 2. If let's say the number I changed can remove 3 columns below RED and the report has only 2 columns for RED then it will automatically removed the third column which is BLUE.
How can I add the if and then where if it's RED and it has "1" or "2" or "3" below it then they need to be removed?
|