Hello All,
I need your help with a VBA code which should split the data from wrapped text cells into different cells / rows. For the ones which are empty, to let them empty.
I tried different macros, but with no luck.
Thanks a lot in advance,
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>Expectation:
<colgroup><col span="3"><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
I need your help with a VBA code which should split the data from wrapped text cells into different cells / rows. For the ones which are empty, to let them empty.
I tried different macros, but with no luck.
Thanks a lot in advance,
ID | Created By | Created | Title | Quarter | Review | Pr Name | Pr Name2 | Platform | Work Done | Hours | Deal Descrip | Issue Descrip |
3 | Alice | 4/1/2016 4:06 | OP | Q2FY16 | 20 | product name1 product name 2 product name 3 | Waived Wi Other | Desktop Mobile On-demand | Work done 1 Work done 2 Work done3 | 45 | Deal description 1 Deal description 11 Deal description 12 | Issue description 1 Issue description 11 Issue description 12 |
4 | Tom | 4/1/2016 4:38 | OP | Q2FY16 | 22 | Product Name 1 Product Name 11 Product Name 1122 | Work Done Work Done 33 Work Done 3344 | 33 | deal description 1 deal description 11 deal description 12 | issue description 1 issue description 11 issue description 12 | ||
5 | Alice | 4/1/2016 4:47 | OP | Q2FY16 | 25 | Product name 1 Product name 2 | work done 1 work done 3 | Deal description 1 Deal description 122 | Issue Description 1 Issue Description 122 | |||
6 | Alice | 4/6/2016 5:50 | OP | Q2FY16 | 30 | Product Name Product Name Description product name different than the above | Audit Pal Wi | Desktop Mobile Services | Work Done 1 comments comments 1 Work Done described in multiple lines | 15 | Deal Description comments comments comments comments comments comments comments comments comments comments comments comments comments comments other Deal Description other Deal Descriptionother Deal Description, other Deal Descriptionother Deal Description other Deal Descriptionother Deal Description. New Deal Description, comments New Deal Description, comments New Deal Description, comments New Deal Description, comments New Deal Description, comments New Deal Description, comments New Deal Description, comments New Deal Description, comments | Issue Description Issue Description Issue Description Issue Description Issue Description Issue Description Issue Description new issue descriptions, new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions new issue descriptions . Issue Issue Description on the customer support Issue Description on the support Issue Description on the support Issue Description on the Issue Description on the support . |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Title | Quarter | Review | Pr Name | Pr Name2 | Platform | Work Done | Hours | Deal Descrip | Issue Descrip |
OP | Q2FY16 | 20 | product name1 | Waived | Desktop | Work done 1 | 45 | Deal description 1 | Issue description 1 |
product name 2 | Wi | Mobile | Work done 2 | Deal description 11 | Issue description 11 | ||||
product name 3 | Other | On-demand | Work done3 | Deal description 12 | Issue description 12 | ||||
OP | Q2FY16 | 22 | Product Name 1 | Work Done | 33 | deal description 1 | Issue description 1 | ||
Product Name 11 | Work Done 33 | Deal description 11 | Issue description 11 | ||||||
Product Name 1122 | Work Done 3344 | Deal description 12 | Issue description 12 |
<colgroup><col span="3"><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>