tominabox1
New Member
- Joined
- Oct 24, 2014
- Messages
- 6
I am completely new to VB so bear with me please! I sometimes have a spreadsheet with data like this:
QTY Ref Des
1 U5
5 C1,4,8-10
3 R10,23,48
1 L2
And I need to expand those "combined" lists so each "ref des" has its own row like this:
QTY Ref Des
1 U5
1 C1
1 C4
1 C8
... and so on.
There is additional data in the spreadsheet rows, these are just the 2 columns that need to be modified during the operation, the rest can just be duplicated/copied.
Any ideas? Thanks
QTY Ref Des
1 U5
5 C1,4,8-10
3 R10,23,48
1 L2
And I need to expand those "combined" lists so each "ref des" has its own row like this:
QTY Ref Des
1 U5
1 C1
1 C4
1 C8
... and so on.
There is additional data in the spreadsheet rows, these are just the 2 columns that need to be modified during the operation, the rest can just be duplicated/copied.
Any ideas? Thanks