yes brother I can do this,but I need a vba code which do this because i do this daily basics ,i want to save my timeWhya VBA when all you have to do is double click on the green square in the bottom rh of cell N2
Range("N2:N" & Range("M" & Rows.Count).End(xlUp).Row).value = Range("N2").value