Creating Simpler Macro

Hi, I've created a very crude macro to shift 3 cells in the A column into the A,B,C rows. It looks like this (keep in mind all i did was use the record function)

Please Login or Register  to view this content.

A1,B1,C1 are fields i don't want to modify, that is why they aren't included.

but what I would like it to see if anyone can create a simpler form of this macro that can go through the whole A column, not just up to A49 like ive done.

I would do this myself if i knew anything about creating macros :P

Thanks guys!

What you need are some nested loops, try:

Please Login or Register  to view this content.

If you have done any programming in general, (even if not VBA) this should be fairly familiar.

Note:
I just threw this together in a rush, I think it's ok but...
In any case it should give you pointers as to how to progress.
Mark.