Text selection macro problem
 

I have varible lengths of data in rows and columns, all moved over t
the 2nd column. Each set of data is seperated by a line item in th
first column. Is there any way to auto-find/seek to each line in th
first coloumn, seek to the second one, go up one, select the dat
above that row (so it picks up all that data, but not the row wit
the name), cut into another worksheet, go back, shift the rows up an
loop until finished. The main thing is that it needs to be able t
select varible lengths of data, and able to seek the data in the 1s
coloumn

Also, how to pause a macro while recording it would be helpful i
possible. Thanks in advance for any help. I'm new to the Excel macr
programming scene and came here first to ask. :