Results 1 to 10 of 10

Split a list in to separate tabs

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Split a list in to separate tabs

    Hi all,

    I am looking for a method of quickly taking a list with multiple possible entries in a column (say column A) and copying all identical entries to a new tab; naming the new tab whatever the entry initially was.

    That is, if column A has entries including 'bus' (12 times), 'car' (19 times) and 'Jumbo Jet' (113 times), then I'm looking to quickly create new tabs called 'bus', 'car' and 'Jumbo Jet' and within these have only the rows that had those entries in column A.

    I have attached two sample sheets to give a better idea. Take sample 1 as being my initial data and sample 2 as how the result might look.

    Thanks in advance for any help/response.
    Attached Files Attached Files
    Last edited by kiboodez; 12-02-2014 at 11:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moving multiple excel tabs into separate tabs/separate files
    By RO24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2014, 11:04 AM
  2. Best option to filter data from one large list to separate tabs
    By DJJAY in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2014, 03:23 PM
  3. Replies: 1
    Last Post: 05-18-2014, 02:12 PM
  4. How Do I split a file into several Tabs, acording to information on other tabs?
    By Edinson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2013, 05:17 AM
  5. [SOLVED] Need to split a LONG list into separate sheets based on repeating, incremental nunbers
    By matrix_machine in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2012, 04:37 PM

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