Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
Column shifting when open excel | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |