Results 1 to 10 of 10

Sorting and grouping data according to one and two words of a Column

Threaded View

terryhenderson Sorting and grouping data... 08-03-2015, 07:06 PM
daffodil11 Re: Sorting and grouping data... 08-03-2015, 08:35 PM
terryhenderson Re: Sorting and grouping data... 08-03-2015, 10:24 PM
daffodil11 Re: Sorting and grouping data... 08-04-2015, 10:59 AM
terryhenderson Re: Sorting and grouping data... 08-04-2015, 04:55 PM
daffodil11 Re: Sorting and grouping data... 08-04-2015, 05:06 PM
terryhenderson Re: Sorting and grouping data... 08-04-2015, 07:00 PM
daffodil11 Re: Sorting and grouping data... 08-04-2015, 08:11 PM
terryhenderson Re: Sorting and grouping data... 08-05-2015, 04:33 PM
daffodil11 Re: Sorting and grouping data... 08-05-2015, 05:16 PM
  1. #1
    Forum Contributor
    Join Date
    04-04-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    204

    Sorting and grouping data according to one and two words of a Column

    Hi Guys,

    I have worksheet1 that has data of 8 columns (A-H) and nearly 7000 rows. All data in are sorted according Column D which is also sorted alphabetically.

    What I am after is a VBA script that will additionally sort data in Worksheet1 according to Column D, but in this time according to the first and second words of each cell in Column D.

    As per uploaded example, all items in Column D that the same first word are moved and sorted in Worksheet2 with an empty row separating each group of data according to that first word.

    The same is for Worksheet3 where all items in Column D of Worksheet1 that have the same first two words are moved and sorted with an empty row separating each group of data according to both first and second words.

    Items in Column D of Worksheet1 with different first, and first and second words are just ignored to stay in Worksheet1.

    Can someone generously help with this matter?

    Thanks in advance.list_of_subjects_example.xlsx
    Last edited by terryhenderson; 08-03-2015 at 07:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting Data and Grouping
    By Forex-Forex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 05:19 PM
  2. Sorting first and second words in one column into two other columns....
    By esy0008 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2012, 02:08 PM
  3. Need help grouping by similar words in second column
    By bigmark1972 in forum Excel General
    Replies: 11
    Last Post: 11-19-2011, 09:09 PM
  4. Grouping and Sorting Data into Sub sections
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2011, 12:20 PM
  5. Auto-Sorting and Grouping data by column
    By CJMathias in forum Excel General
    Replies: 4
    Last Post: 10-24-2010, 12:14 PM
  6. Data Sorting/Grouping Function
    By Blake 7 in forum Excel General
    Replies: 0
    Last Post: 10-19-2010, 02:50 PM
  7. Grouping and sorting data
    By coffee_n_tv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2008, 06:44 PM
  8. [SOLVED] grouping and sorting data
    By mb7q in forum Excel General
    Replies: 0
    Last Post: 03-30-2006, 03:35 PM

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