HTML Code:Hi Team, I need your help, Task is to read the cell values from Column C of input file on by one till LastRow. if range("c3") = "ABC" and range("c4") = "XYZ" then insert a blank line below c4.and Range("C3:C4") needs a Border as shown in Output sheet. and in Column A3 mention Situation 1. merge cell ("A3:A4") Increase Situation 1,2,3 and so on... Usually at last we will not come across abc and xyz simultaneously. then remaining data should bebordered like a box. I am attaching input data file , I want the result in input sheet only, not in a output sheet. Thanks for your help. Regards,MG.
Reply With Quote