Thread: [Solved] Remove Red macro
View Single Post
 
Old 03-15-2013, 12:37 PM
netchie netchie is offline Windows XP Office 2007
Novice
 
Join Date: Jun 2011
Posts: 24
netchie is on a distinguished road
Default

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?
Reply With Quote