I am trying to search an excel sheet in a row by a specific char such as "abc" when I find abc. I want to put abc in sheet 2 under the column that it should belong in. Also column ABC will have 10 columns after this associated with it that also have to be migrated. After migrated ABC I will want to migrate XYZ which I will have to migrate the next 5 columns with.
All groups such as ABC and XYZ have different number of columns that are needed for it, so I have to find a way to specifically look for the char name and according to that name copy the columns associated with it to a spreadsheet that has these char predefined.