This is getting way beyond my skill level, and as a result I may hav
high expectations of what is actually possible, but here goes anyway!

I have a list of data that has been dumped into excel from anothe
application. The data in each column represents related informatio
with the end of each set of related data being separated by th
following text string in column A
#~~~~~#
Each “set” of data can vary in length from 1 row of data up to 15 row

There are 14 columns of information (Columns A – N)
In column B at the beginning of each set of data there is a “category
eg Product A, Product B

ColA ColB ColC ColD ColE ColF etc
<textA ProdA <textC <textD <textE <textF
<textD <textE <textF
<textD <textE <textF
#~~~~~#
<textA ProdA <textC <textD <textE <textF
#~~~~~#
<textA ProdB <textC <textD <textE <textF
<textD <textE <textF
#~~~~~#
<textA ProdB <textC <textD <textE <textF
<textD <textE <textF
<textD <textE <textF
#~~~~~#


Basically what I am trying to automate is moving some of this data int
a presentable preformatted worksheet, where the format ends up somethin
like this

ColA ColB ColC ColD ColE ColF etc

ProdA
<textC <textD <textF
<textD <textF
<textD <textF
<textC <textD <textF

ProdB
<textC <textD <textF
<textD <textF


<textC <textD <textF
<textD <textF
<textD <textF


Any help would be appreciated

Thanks

Kare

--
ks
-----------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...nfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=49099