Results 1 to 10 of 10

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

Threaded View

Ocean Zhang Create New Worksheet Based On... 02-28-2013, 10:45 PM
Ocean Zhang Re: Create New Worksheet... 02-28-2013, 11:31 PM
jindon Re: Create New Worksheet... 02-28-2013, 11:54 PM
Ocean Zhang Re: Create New Worksheet... 03-01-2013, 12:12 AM
Ocean Zhang Re: Create New Worksheet... 03-01-2013, 12:28 AM
jindon Re: Create New Worksheet... 03-01-2013, 12:54 AM
Ocean Zhang Re: Create New Worksheet... 03-01-2013, 02:17 AM
jindon Re: Create New Worksheet... 03-01-2013, 02:35 AM
Ocean Zhang Re: Create New Worksheet... 03-01-2013, 03:04 AM
arlu1201 Re: Create New Worksheet... 03-01-2013, 03:26 AM
  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

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

    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!
    Attached Files Attached Files
    Last edited by Ocean Zhang; 02-28-2013 at 11:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1