Hello..I am looking to insert a new row based on a criteria. In Col. 'K', I have values '0' and '-1'. I have the column sorted so that all the '0' are sorted first then follows the '-1'. What I want is right after the last row where cell value in COl. 'K' is '0', insert a new row and type in 'Sales' in Col. 'K'. For example:
Before:
FruitsDeptStockApple010Orane020Papaya030Mango-140Strawberry-150Banana-160
After:
FruitsDeptStockApple010Orane020Papaya030SALESMango-140Strawberry-150Banana-160
Thank you in advance!