macro to copy down until end of text

[1038102j]

So here are the steps I did: clicked "record macro" with relatative ref. i go through my steps, insert 15 columns then copy and transpose data, then copy data from above 16 lines, then copy market/quarter/year down. (you will understand, bottom of file describes my method) etc. etc. etc.. So once i do all of that, i click stop, but when I run macro on next line of data down my macro just runs the above data - that has already been transposed/copied down. It is completely out of whack.

Can someone re-write/help with the proper macro that will continue this data until the end of text. Basically, I have 5k lines that need to be transpose/copied down. I clearly am a rookie with macro's.

If unclear please let me know and I will try and be more specific.


Current Macro:

Please Login or Register  to view this content.

[davesexcel]

It is hard to understand what you are trying to do in your example.