Hi, I have a problem, I want to automate some layout in my excel sheet using macro. Please find attached image: https://ibb.co/nPOkBR (source)
So that is the source. And what the result that I want is as follow : https://ibb.co/eJMBkm (expected result)
The logic is:
1. the last column is column G
2. If the active column exceeding column G, then It would be moved into the row below the last row.
3. the column A (Name) will be repeated for each new movement.
4. If after move the column into new row and the active column still exceeding the column G, then it would be moved again to the next row below until the last active column doesn’t exceed column G.
Please forgive for bad explanation. You will understand if you see the source image and the expected result.
Please share the idea how to do this using macro! You will help me a lot!