Your request is short on details.

What sort of data is it? What outcome do you want? Paste what into
Sheet2, cell A1?

FYI-
To count used rows in column A, try =COUNTA(A:A)

Substitute A:A for your column of choice.


HTH,
JP

On Mar 19, 8:32*am, wrote:
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