Busybeaver
New Member
- Joined
- Nov 26, 2010
- Messages
- 20
Afternoon and Happy New Year to all
Can someone please help me with a code for the below. What I'm trying to achieve is to insert rows below each line based on the number of lines required in the last column. I.e. No rows need to be inserted for the first 2 lines but 2 additional rows need to be inserted for the 3rd line.
I have tried so many codes that I have found online but can only find codes that will insert either only 1 row at a fixed range or will only insert rows once.
Unfortunately I don't have the knowledge to attempt to write a code like this by myself but would greatly appreciate any help from someone who does.
Can someone please help me with a code for the below. What I'm trying to achieve is to insert rows below each line based on the number of lines required in the last column. I.e. No rows need to be inserted for the first 2 lines but 2 additional rows need to be inserted for the 3rd line.
I have tried so many codes that I have found online but can only find codes that will insert either only 1 row at a fixed range or will only insert rows once.
Unfortunately I don't have the knowledge to attempt to write a code like this by myself but would greatly appreciate any help from someone who does.
CRM | Task Open | Category | Address | Suburb | DEL/REM | Bin type | Bulk # | PID # | Total line Count |
212226/2020 | 21-Dec-20 | *** | *** | *** | DEL | FOOD | 0 | ||
211640/2020 | 21-Dec-20 | *** | *** | *** | DEL | FOOD | 0 | ||
212343/2020 | 22-Dec-20 | *** | *** | *** | DEL | FOOD | 3 | 2 | |
211704/2020 | 21-Dec-20 | *** | *** | *** | DEL | FOOD / GLASS | 1 | ||
206386/2020 | 21-Dec-20 | *** | *** | *** | DEL | RUBBISH / RECYCLING / GLASS | 2 | 5 | |
212350/2020 | 22-Dec-20 | *** | *** | *** | DEL/REPAIR | RUBBISH / FOOD | 1 |