shifting headings over on column

A

arthurf

Main Heading 1

Main Heading 2

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata
somedata somedata somedata
somedata somedata somedata

and it should look like the following:

Main Heading 1

Main Heading 2

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata

Column_Heading1 Column_Heading2 Column_Heading2
somedata somedata somedata
somedata somedata somedata
somedata somedata somedata

NOTE: the data is dynamic so the headings will not always be in the same place.
My new approach is to change all of the headings because of the unique nature of
the string one by one, but when I get to the first example from above there is no
heading above the somedata column, so therein lies the problem. All of this will
be done in a macro and any help will be appreciated.

thanks
A
 
Top