Hello! I have a spreadsheet with two tabs: In PLAN1 I have a single column with several data, but they do not follow a sequence. The values that can be found in this column are: Product code (Ex: AAA7X), A xxxx, B xxxx, C xxxx, D xxxx, E xxxx, F xxxx, G xxxx, and Total xxxx. I need the values that are between one product code and another to be copied and pasted to a line in PLAN2. In PLAN2 I have a header with the possible data to be found in the PLAN1 column. Here are the images:
I'm learning VBA with Macros writing, but this one can not do the paste in the correct columns! I would like an aid in programming the code, how do I perform the copying and pasting of cells in the corresponding column and so that it goes to the next line in Plan2 when a new product code is found in Plan1! Thank you