+ Reply to Thread
Results 1 to 5 of 5

Select Unique Data use it create worksheet(s) populate correct sheet with correct data

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    town, country
    MS-Off Ver
    Excel 2007
    Posts
    3

    Select Unique Data use it create worksheet(s) populate correct sheet with correct data

    Test.xlsx

    So this is doing my head in and I'd appreciate any help...

    On the attached sheet (test) is a list of people, with specific types of SIM cards, belonging to specific centres.

    I would like to be able to select a list of the unique centre numbers, create worksheets within this work book with the corresponding Unique centre numbers.

    One this is complete I would like to put the correct data from the raw data on the corresponding centre number sheets. As per Results.xlsx

    Finally I would like to save each of the sheets as its own file.



  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Select Unique Data use it create worksheet(s) populate correct sheet with correct data

    Finally I would like to save each of the sheets as its own file.

    Are you creating separate books, or worksheet? If you creating separate sheets(tabs), then you are not creating new book, i.e. new sheet will remain on the same workbook.

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    town, country
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Select Unique Data use it create worksheet(s) populate correct sheet with correct data

    In the end I want to have seperate workbooks, however it isn't important if in the interim this information is transferred to new sheets or books.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Select Unique Data use it create worksheet(s) populate correct sheet with correct data

    This code creates sheets(tabs)on the same workbook

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-21-2013
    Location
    town, country
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Select Unique Data use it create worksheet(s) populate correct sheet with correct data

    Thanks this is brilliant!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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