i have this line code in worksheets change event it works very well and i like it but, the data it begins from row 4 in column a when fill data in col b automatically add number 4 in col a in row 4 but, what i would the code has to make adding number 1 in row 4 then become the rest data entering 2,3,4 in rows 5,6,7
i hope somebody help