How do i copy section headings automatically in excel
 

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.

How do i copy section headings automatically in excel
 

Assuming each set of headers are separated by an equal number of lines in
between, viz headers are in A1:B1, then in A10:B10, then A19:B19, A29:B29,
etc (ie 9 lines in between headers)

Places in say, E1: =OFFSET(A$1,ROW()*9-9,)
Copy E1 to F1, then fill down until zeros appear, signalling exhaustion of
headers
--
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.

How do i copy section headings automatically in excel
 

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.