wapcoslucknow
New Member
- Joined
- Oct 17, 2020
- Messages
- 14
- Office Version
- 2007
- Platform
- Windows
Hello,
I need a very special answer from you, since I am not fluent in VB, I am not able to sole it.
I have a group (slave group) in Excel like: -
And a master group like: -
Master group has 9 elements, whereas sub group can have any number of elements from these 9 items (maximum 9). Here, 6 members out of 9.
My requirement is arranging sub group like: -
Here, blank rows are inserted, as per master group i.e. master group has to be followed and blank row should be inserted at missing points.
Also there will be so many sub group in the same sheet (one after other downwards)
I hope you understand my question.
Thanks
I need a very special answer from you, since I am not fluent in VB, I am not able to sole it.
I have a group (slave group) in Excel like: -
HT line length | 0.01 |
HT Poles | 4 |
LT Line Length | 0.56 |
LT Poles | 10 |
DTR 25 KVA | 2 |
BPL | 118 |
And a master group like: -
HT line length |
HT Poles |
LT Line Length |
LT Poles |
DTR 10 KVA |
DTR 16 KVA |
DTR 25 KVA |
DTR 63 KVA |
BPL |
Master group has 9 elements, whereas sub group can have any number of elements from these 9 items (maximum 9). Here, 6 members out of 9.
My requirement is arranging sub group like: -
HT line length | 0.01 |
HT Poles | 4 |
LT Line Length | 0.56 |
LT Poles | 10 |
DTR 10 KVA | |
DTR 16 KVA | |
DTR 25 KVA | 2 |
DTR 63 KVA | |
BPL | 118 |
Here, blank rows are inserted, as per master group i.e. master group has to be followed and blank row should be inserted at missing points.
Also there will be so many sub group in the same sheet (one after other downwards)
I hope you understand my question.
Thanks