I am trying to build macro to put 5 rows 5 columns

I am trying to build a macro that put 5 rows and 5 columns to each rows.

it doesn't have to be a same sheet, if it copys 1st line and add 5 rows and fills it with the starting rows will do..

any idea ? where to start? I am pretty new to this macro stuff.


Thank you for your help!!



AC DB DQ Aq ag zq
DC do A1 B2 C5 zz
iu io AA Q H 3


to


AC DB DQ Aq ag zq
AC DB DQ Aq ag zq
AC DB DQ Aq ag zq
AC DB DQ Aq ag zq
AC DB DQ Aq ag zq
AC DB DQ Aq ag zq
DC do A1 B2 C5 zz
DC do A1 B2 C5 zz
DC do A1 B2 C5 zz
DC do A1 B2 C5 zz
DC do A1 B2 C5 zz
DC do A1 B2 C5 zz
iu io AA Q H 3
iu io AA Q H 3
iu io AA Q H 3
iu io AA Q H 3
iu io AA Q H 3
iu io AA Q H 3

Are you still using XL2003 ? If not please amend your profile accordingly. Thx

Formula ..

In Sheet2

Formula:

Please Login or Register  to view this content.

Copy across and down

Please Login or Register  to view this content.