Macro to Segregate values from cell and copy paste

[shan]

Hello Everybody,

Good Afternoon !!

Request your assistance for macro.

Need a macro
1. To segregate the values available in C and D column in individual cell.
2. Insert that many rows and paste these value along with rest column each after each.

For more understanding I have attached a file.

Thanks ,
Shan

[p45cal]

In a given row, will it ever be the case that both columns C and D will have multiple values? If so, what do you want to happen?

[shan]

This will not be a case ... the multiple values will feature in either C or D .... please note there is no restriction on the multiple values.

[p45cal]

Click the button in the attached workbook.. does it do what you want?

[shan]

Thank you so much.