Hey Ron.

Im not sure if i follow exactly what your saying. The
Range("A1:A100") " It varys each time i copy data to the blank sheet.
What is the code that you provided supposed to do. I ran it, and i
seems to do nothing

--
jim hense
-----------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26889

Hi Jim

It will look in A1:A100 for "station number" (in Sheet1)
It will copy the 4 rows below it to "Sheet2"
It will do this for every "station number" in the range

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jim hensen" wrote in message ...

Hey Ron.

Im not sure if i follow exactly what your saying. The "
Range("A1:A100") " It varys each time i copy data to the blank sheet.
What is the code that you provided supposed to do. I ran it, and it
seems to do nothing.


--
jim hensen
------------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...o&userid=15155
View this thread: http://www.excelforum.com/showthread...hreadid=268890