I've recorded a macro and it is working fine, except for one thing.
Basically the macro copies content from worksheet1 and paste it into
worksheet2 in a different order on a single row.

When the copy is done I wnat to position the cell on Cell B# - the next row
dwon on workshett2. For example when the Macro ends I'm in Cell AH3 of
worksheet2. I won't to go back to Cell B4 to start the macro again (manually
because I have to close the current worksheet1 and open another). The next
time the macro ends I'm in Cell BA4 of worksheet2. I want to go back to Cell
B5.... and so on. I use the ActiveCell(0,1) to move the active cell in
worksheet2 along during the copy/paste. The problem I'm having is that I'm
never on the same cell reference of worksheet2 when the macro ends. Hope this
makes sense and that there is an easy solution.

Thanks
John