Create New Worksheet Based On Values within a Cell, then Insert Row

**Ocean Zhang** · 02-28-2013, 10:45 PM

I hope this is something that can be done in Excel:

This has 2 parts:

1. In column O, I have comma-separated values that represent different product categories. For each unique comma-separated value, I want to create a new worksheet within the current workbook with the same sheet name as the comma-separated value.

2. Insert each row into the corresponding new sheets.

See example sheet attached.

1. From column O, there are 10 comma-separated values, 8 of which are unique, so these 8 new sheets would be created: diaper bags, feeding, shopping, decor, rockers, strollers, play, bath.
2. Row 1 would be inserted into the following worksheets: diaper bags, feeding, and shopping. Row 2 would be inserted into decor and feeding. Row 3 would be inserted into rockers, strollers, play, bath, diaper bags.

If it's not possible to insert the entire row, then inserting just values in column A would be good enough.

Thanks!

**Ocean Zhang** · 02-28-2013, 11:31 PM

I forgot to include the attachment with my original post. Edited to add attachment.

**jindon** · 02-28-2013, 11:54 PM

See if this is how you wanted.

**Ocean Zhang** · 03-01-2013, 12:12 AM

Wow, You're my HERO! Awesome stuff. Thanks so much!

**Ocean Zhang** · 03-01-2013, 12:28 AM

Wait, there was a problem somewhere. For some reason it worked on the example worksheet, but it didn't work properly on my actual production sheet.

I've uploaded the actual file I'll be working on.

Thanks so much for your help!

**jindon** · 03-01-2013, 12:54 AM

1) Replace "Sheet1" with "Complete Vendor List"

2) You have invalid character for the sheet name.
e.g
: \ ? [ ] / *

You need to delete all these from the categories.
And the Length of the sheet name MUST be less than 31 characters.

**Ocean Zhang** · 03-01-2013, 02:17 AM

Okay, I cleaned it up and tried again. This time I get a run time error

I attached my current version without special characters and less than 31 characters long. Can someone please investigate?

Thanks!

**jindon** · 03-01-2013, 02:35 AM

Can you change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Ocean Zhang** · 03-01-2013, 03:04 AM

Yes, it worked! Thanks!

**arlu1201** · 03-01-2013, 03:26 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Create New Worksheet Based On Values within a Cell, then Insert Row

LinkBack

Thread Tools

Rate This Thread

Display

Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Re: Create New Worksheet Based On Values within a Cell, then Insert Row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions