Results 1 to 1 of 1

Thread: VBA Code for Sorting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA Code for Sorting

    Dear Experts,

    I have a set of data as shown below

    Category A Name Due Year
    Sam 2021
    John 2020
    Tony 2024
    Rahul 2020
    Harry 2023
    Category B Bill 2021
    Tom 2022
    Steve 2020
    Alan 2024
    Walter 2021

    I want to create tabs with three different colors which will show the list data as per conditions.
    Category A Red Yellow Green
    Category B Red Yellow Green

    When I click on Red tab of Category A, it will list all names with due date 2020 or earlier
    When I click on Yellow tab of Category A, it will list all names with due date between 01-01-2021 to 12-31-2023
    When I click on Yellow tab of Category A, it will list all names with due date after 01-01-2024

    and similarly for Category B.

    When I click on Red tab of Category B, it will list all names with due date 2020 or earlier
    When I click on Yellow tab of Category B, it will list all names with due date between 01-01-2021 to 12-31-2023
    When I click on Yellow tab of Category B, it will list all names with due date after 01-01-2024

    Any help?

    Regards
    Soumen
    Last edited by soumen21; Oct 17th, 2019 at 02:57 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •