HElp needed for a small Excel macro

[j2007]

I wanted to copy data from cell sheet 1 A1 to B24,
paste it into two sheets in 24 columns As in one sheet (sheet 2), Bs in another
sheet (sheet 3)
and continue the next 24 (A25 to B48)
paste in the same sheets under row A1 to A24 (sheet 2), and under B1 to B24
and continue till all the data in sheet 1 is done.
Thanks

I am a newbie, so Please Help.

[Killer42]

I wanted to copy data from cell sheet 1 A1 to B24,
paste it into two sheets in 24 columns As in one sheet (sheet 2), Bs in another
sheet (sheet 3)
and continue the next 24 (A25 to B48)
paste in the same sheets under row A1 to A24 (sheet 2), and under B1 to B24
and continue till all the data in sheet 1 is done.

The easiest way to get going on something like this in Excel is to start recording a macro, then do the operation "manually". Then, when you stop recording, you have all the VBA code there in the recorded macro, so you can play with it.

Depending on the situation, this may produce exactly what you need with no further work required. But at the very least, it will provide the building blocks for your macro.