Macro to split Cells delimter comma to multiple Rows.

**pavan5183** · 05-16-2013, 11:04 AM

Hi,

I need a Macro to split the contents of cell, delimiter would be "," and the out put has to be in the same sheet.

Adding to the above requirement, corresponding values to that also needs to be copied.

I have attached a sample data.

Any help on this will be really appreciated

Thanks,
Pavan.

**nilem** · 05-16-2013, 12:55 PM

Hi Pavan,
try it

Please Login or Register  to view this content.

**pavan5183** · 05-17-2013, 02:56 AM

Thanks Nilem for the code. The data is getting created in different rows.

I should have been more specific, the code should overwrite the existing data.

And there would be instances where Rep Column cells might be blank also.

Could you please edit the code.

**AB33** · 05-17-2013, 04:05 AM

Try the attached

**nilem** · 05-17-2013, 04:52 AM

or

Please Login or Register  to view this content.

**pavan5183** · 05-17-2013, 10:24 AM

Sweet!..Its Working!!

Thanks a Ton!! Nilem.

I really appreciate it..

Cheers!!

Macro to split Cells delimter comma to multiple Rows.

LinkBack

Thread Tools

Rate This Thread

Display

Macro to split Cells delimter comma to multiple Rows.

Re: Macro to split Cells delimter comma to multiple Rows.

Re: Macro to split Cells delimter comma to multiple Rows.

Re: Macro to split Cells delimter comma to multiple Rows.

Re: Macro to split Cells delimter comma to multiple Rows.

Re: Macro to split Cells delimter comma to multiple Rows.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions