Hi,

I receive a daily Excel file with data collected from a website where
clients register. The data is all contained in Column 1. There are a
variable number of clients with 16 data elements per client, and all
the HTML tags are intact.

Using VBA, I can determine the range, how many clients are represented
and I can extract the pertinent data from the HTML tags.

My problem is posting each individual client to one row in another
spreadsheet and posting the next client in the row underneath the
first, etc.

I tested the code by using a named range that represented only one
client's data using a For Each...Next loop, and posting the data to one
row on another spreadsheet.

I don't know how to go back to the raw data and pick up the next
client, post that data to the next row, and so on.

I tried using a dynamic array as:

Dim ClientArray() As Variant
Dim intClient As Integer
Dim intData As Integer
ReDim ClientArray(1 To ClientCount, 1 To 16)
For intClient = 1 To ClientCount
For intData = 1 To 16
THIS IS WHERE I DON'T KNOW WHAT TO DO
Next intData
Next intClient

Or is there a better way?

Thanks for your help.


--
DataCollector
------------------------------------------------------------------------
DataCollector's Profile: http://www.hightechtalks.com/m368
View this thread: http://www.hightechtalks.com/t2295175