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
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of October 24, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel