+ Reply to Thread
Results 1 to 1 of 1

VBA auto sort a dynamic list with formulas

  1. #1
    Registered User
    Join Date
    06-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    VBA auto sort a dynamic list with formulas

    Hello all,

    I have a problem and desperately need your help!

    I have a workbook with 2 sheets. Sheet1 contains a large list with 5 columns (B:F) with the header on row 2 and the data on rows 2 to 225.

    The columns are:
    B: Date
    C: Department
    D: Employee
    E: Cost

    With an array formula I managed to create another list next to it allowing me to dynamically filter the main list, for example showing only Department 6. Pretty much like automatic filter by with a formula so it happens dynamically. Please see the attached workbook with the example.

    On a second sheet I want to show the dynamic list (i.e. Department 6) but automatically sorted by the date.

    For this sheet I included the following VBA:

    Please Login or Register  to view this content.

    If the list on sheet1 changes, it should automatically update the filtered and sorted list on sheet2. But that doesn’t yet work. I have absolutely no idea about VBAs and only found the above in this forum. It works if you click into one of the cells on sheet2 and click enter. But it doesn’t happen automatically, unfortunately.

    How do I need to change the VBA text to make this happen?

    I hope I was able to explain, it is all very new to me, so please be kind with your replies!!

    Thank you for your help and in case of any questions, pls do let me know!
    Attached Files Attached Files
    Last edited by JBeaucaire; 04-20-2013 at 10:37 AM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

+ Reply to Thread

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