If the cells below each set of headers are blank (here it doesn't matter if
the number of lines in between headers vary), think you could try this ..

Copy n paste cols A and B into a new sheet. In the new sheet, select cols A
and B. Press F5 Special Check "Blanks" OK. This selects all the blank
cells in cols A and B. Then just right click on the selection Delete
Entire row OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"awolxx" wrote:
I have a large list of data split into sections: A1:b1 contains
heading/description c1:d8 contains data. A10:b10 contains the next
heading/description with data in c10:d20 etc. I was hoping there was a
function in excel to automatically copy the headings beside the data.