+ Reply to Thread
Results 1 to 1 of 1

Automated Sorting and Grouping VBA

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    1

    Automated Sorting and Grouping VBA

    Hi guys,
    even though I have been on this site many times and it was great help in solving VBA problems, this is my first post here.

    The thing, is a supposed to develop a project management tool, which automatically adds new tasks and in the list, sorts them accordingly and then groups them depending on the categories. By that I mean, 1.0.0. is the main category, 1.1.0. is sub category etc...

    I have found a helpful macro on this site regarding grouping and other parts I have put together with writing and recording the macros.
    I admit, it is not the most elegant way how to deal with it, but was the only way know.

    The problem is, after some time, the sorting function stops to work for some cells and i cannot find the origin of this issue.
    Can you please have a look at this problem. The file is attached.

    P.S. The strange numbers (999999999999999999999) at the end of the list are there to set the border for grouping macro.

    Thanks a lot,

    Ivan
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automated data sorting
    By Lloydy28 in forum Excel General
    Replies: 1
    Last Post: 09-16-2012, 09:37 AM
  2. Help with grouping/sorting
    By ceverett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2011, 04:00 PM
  3. Automated Data Sorting/Table Creation
    By bwp2006 in forum Excel General
    Replies: 1
    Last Post: 02-17-2011, 08:40 PM
  4. Automated Database Sorting
    By jtang128 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2010, 01:59 PM
  5. Automated Grouping / Total Query
    By Plusone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2007, 08:58 AM

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