Selecting Specific Data to copy/move to a new sheet

K

ksp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to sum cells across different worksheets in different locat 4
looping required 5
Autofull formual 1
Macro or formula to copy data based on criteria 1
Code Help 2
Repeat header on each row until data change 0
Return Top values with changing criteria 9
Merging/Combining workbook data 5

Top