Perhaps you can insert a simple sequence in column F, 1, 2, 3, etc -
this will enable you to get the data back into the correct sequence
afterwards. Then you can sort the data on column E, so that all the
blanks go to the end of the block of data, and then sort just the
block of data using column F.

Does this get you nearer to what you want?

Hope this helps.

Pete

On Oct 22, 4:36*pm, Rick wrote:
Hi Pete,

My explanation of the Header texts may not have been clear. *So let me give
an example.

Header1 * Nuts
Header2 * Bolts
Header3 * Widgets
Header4 * Gigets

The text for the 4 Headers will always be the same, but the Headers are not
identically named. *That is, Header1 will always say Nuts on every report,
but never Bolts or any of the other 3 Header names.

I hope this is a better explanation of the Headers text.

This was why I was trying to key off of the Headers, as they remain the same
from report to report. *Even though their row location may vary. *So I tried
doing a Search and every other thing I could think of in Col A, keying off of
the Header names. *I have not been able to come up with a solution. *I was
hoping you or someone else would.

Thanks for your expert help.
--
Rick



"Pete_UK" wrote:
Your example shows the data regularly spaced. Are you saying that
there may be more than one blank row between each segment of data, and
that this varies each time you import the report? Does the data Header
1 always appear in the same (starting) cell?

Pete

On Oct 21, 11:29 pm, Rick wrote:
Excel 2003.
A report has in col A, 4 Headers (or segment titles) for the report which is
in 4 parts, in Sheet1. *Also data is in Col A below the 4 Headers. *Also in
Col E is data that corresponds with the labels in Col A (on the same rows). *
However the report does not come thru with the 4 Headers/segment titles in
the same row in Col A all the time, it varies. *Also the data shifts rows,
and is not in the same place all of the time. *

I wanted to rearrange the data so that it is in the same rows/cells all of
the time, by linking them to a different tab in the same workbook, Sheet2.. *
That way all of the Headers and data are in the same place each time on
Sheet2.

I have tried Vlookup, Match, Mid, Hlookup, Offset, and everything else but
it will not bring the 4 Headers and data from Sheet1 to Sheet2.

The 4 Headers have the same title text in them each time. *So I tried to key
off of that via Offset and everything else, but was not successful.

I want to rearrange the data so that it will be automatically charted ever
time, via links to Sheet2.

Sheet1 layout below.

Col A * * * * * Col E

Header1
Data1 * * * * *Other Data1 in Col E

Header2
Data2 * * * * *Other Data2 in Col E

Header3
Data3 * * * * *Other Data3 in Col E

Header4
Data4 * * * * *Other Data4 in Col E

Thanks for your expert help.
--
Rick

.- Hide quoted text -

- Show quoted text -