Counta
 

Hi I need some script to count a rows in a column in sheet1 & in
sheet2 pate value in cell a1, then a2 when macro is run again and so
on a3,a4 this is so that i can audit if any rows have gone missing.

Thanks