I have a basic macro (compliments of macro builder) but
want to repeat the same steps x times.

My macro is cutting, pasting, and deleting rows in a
prospect database. For each contact I have 4 rows of data
and want to consolidate to 1 row, and then delete the
three blank rows. Then move onto the next contact record.

How do I loop the steps or use the Dim counter to cycle
through 1000 rows?

I'd appreciate any good resources for a beginner.

Thanks in advance.
Andrew