I am trying to create a macro that will:
1. Find the cell to the right of where there is an ‘AE’ in column B
2. Copy that cell (example: C1 (2184535300005))
3. Paste in the cells below it until there is an ‘AE’ in column B
4. Repeat with the ‘new number’ (example: C6 (2184536200075))
See the original table and the result I am trying to get!!