pasting data and macros
 

I am copying large blocks of data into excel and want to run a macro that
1. allows me to paste special, text the data.
2. then automatically moves to the cell below the last data cell so I can
paste the next batch of data.

Thanks a ton!!!