PDA

View Full Version : [SOLVED] Macro to Segregate values from cell and copy paste



shan
07-06-2015, 01:14 AM
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
07-06-2015, 01:42 AM
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
07-06-2015, 02:40 AM
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
07-08-2015, 01:49 PM
Click the button in the attached workbook.. does it do what you want?

shan
07-08-2015, 10:47 PM
Thank you so much.