Seba Robles
Board Regular
- Joined
- May 16, 2018
- Messages
- 71
- Office Version
- 2019
- 2016
- Platform
- Windows
I'm trying to write a code that helps me speed up a manual process but can't seem to figure it out.
What I'm trying to achieve is for the code to go through all of the cells with data under column B until it find a cell value different from the number 1,
If a value <>1 is found, I want to insert rows below that equal to the cell value it found minus one
After the new row(s) are inserted, I want to fill down the data on columns F through Z
Look at the screenshot for a better example
On row 406, the code identified that cell B406 is 2, so it will insert 1 row below B406 and fill that newly created row (B407) with data from B406 for columns F through Z
On row 413, the code identified that cell B413 is 3, so it will insert 2 rows below B413 and it will fill the newly created rows (B414 and B415) with data from B413 for columns F though Z
And then loop from row 1 until the last row with data
Hope that is clear and will appreciate any help!
What I'm trying to achieve is for the code to go through all of the cells with data under column B until it find a cell value different from the number 1,
If a value <>1 is found, I want to insert rows below that equal to the cell value it found minus one
After the new row(s) are inserted, I want to fill down the data on columns F through Z
Look at the screenshot for a better example
On row 406, the code identified that cell B406 is 2, so it will insert 1 row below B406 and fill that newly created row (B407) with data from B406 for columns F through Z
On row 413, the code identified that cell B413 is 3, so it will insert 2 rows below B413 and it will fill the newly created rows (B414 and B415) with data from B413 for columns F though Z
And then loop from row 1 until the last row with data
Hope that is clear and will appreciate any help!