Auto - Insert a row

[avinashraste]

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