avinashraste
Board Regular
- Joined
- Mar 12, 2008
- Messages
- 167
Dear all,
I have a sheet where cell E2 & H2 are quantities. Cell E2 is original quantity, and H2 is matching quantity. If H2 is not matching with E2 then the whole row becomes colored. Up to this everything is fine. These things are working great. But I want it in a way that as soon as cell H2 is filled with unmatched quantity, a blank row will be added below the original row with all the original formulas and conditional formatting with no data. Is it possible? If yes then please guide step by step if any VBA coding is involved as I am not well versed with VBA code
Thanks & Regards
Avinash Raste
I have a sheet where cell E2 & H2 are quantities. Cell E2 is original quantity, and H2 is matching quantity. If H2 is not matching with E2 then the whole row becomes colored. Up to this everything is fine. These things are working great. But I want it in a way that as soon as cell H2 is filled with unmatched quantity, a blank row will be added below the original row with all the original formulas and conditional formatting with no data. Is it possible? If yes then please guide step by step if any VBA coding is involved as I am not well versed with VBA code
Thanks & Regards
Avinash Raste