Hi Biff,

When I pull data off the web, it comes in as this one time:

Data
Number
Number

Data2
Number
Number

And this the next time:

Data
Number
Number
Number
Number

Data2
Number
Number
Number
Number

What I want to do is extract this information and place it into another
worksheet as:

Data Number Number
Data2 Number Number

And the next time as:

Data Number Number Number Number
Data2 Number Number Number Number

It changes each time up to as many as 10 rows for each of the Data I'm
trying to extract. There is always a blank cell between the last
number of the first set of Data and the start of Data2.

Hopefully I've explained this correctly.

Thanks for your help!

Pat


--
patfergie44
------------------------------------------------------------------------
patfergie44's Profile: http://www.excelforum.com/member.php...o&userid=35581
View this thread: http://www.excelforum.com/showthread...hreadid=553472