shifting headings over on column
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 |
All times are GMT +1. The time now is 04:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com