Hi,

I'm new to VB programming but I'm sure that what I want to do is quite
simple. I have a 2 spreadsheets with 30,000 rows each. Every 12th row
has a number in it which I would like to put into the above 11 cells
automatically. I can use AutoFill for this, but this will result in
over 5,0000 operations. Can anyone give me any pointers as to how I
would go about writing a macro for this?

My initial guess is that I will need to use a FOR loop/AutoFill
feature but thats about it.

Any help would be appreciated.

Andrew