Hi,
I am trying to format the sheet like a numbered sequence.
I have in the sheet , different copy past items with their headings with same no of column.
In A1 - FAB is the first heading, second one is A83- Mar
For these items sub headings aa, bb, cc..
in this , i want to do is, insert a column and put FAB in all the rows where FAB data is there. eg:Till row80, then it will be followed by MAR till row 93.
and where ever Com appears in Col A, the corresponding Col C row data must be moved to COl D previous row..
for eg: if it is in C72, then it will moved to D71.
Like this , i have 700 rows.
i am trying to create a macro using array , can anybody help?
So the macro should find where ever main heading exist, then it should remove the row and insert a column in A copy that heading to full row till that data completes.
I have attached data as well as output desired..
Bookmarks