+ Reply to Thread
Results 1 to 9 of 9

Fetching Specific Data and Sorting

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Fetching Specific Data and Sorting

    Hi Frndz,
    i have yearly data of students i need to show data if i selected some Specific Month (Eg: Feb) then need to show only Fen Month Students data in Second sheet

    Sheet1 Yearly data of student
    Sheet2 Cell A1 Dropdown month's
    Need to show data from Sheet1 on post Cell A1

    when i will change the month (Sheet2 Cell A1)the data to change as per the month also the student name to be sorted alphabetic order.

    ThankS

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,032

    Re: Fetching Specific Data and Sorting

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Fetching Specific Data and Sorting

    Sheet1.pngSheet1.pngSheet2.png

    please am unable to attach excel file please refer the attached images

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,032

    Re: Fetching Specific Data and Sorting

    Try this code in your Sheet2 Module:

    Please Login or Register  to view this content.
    Last edited by xladept; 10-28-2017 at 02:52 PM.

  5. #5
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,467

    Re: Fetching Specific Data and Sorting

    Another variant, with "combobox" ... but ... I'm not "F.e.RN.an.D.e.Z" ("Hi Frndz") ... ... maybe Rodrigo ...
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Fetching Specific Data and Sorting

    thanks for help i have one more doubt if i need to avoid the column of Class and Month then where i need to be change the range selection

    it would be a great support if can solve this

    Thanks
    Liju

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,032

    Re: Fetching Specific Data and Sorting

    You're welcome! I don't understand your new issue

  8. #8
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Fetching Specific Data and Sorting

    i need only fields Employee Name, Activity and Month, i have to avoid the column class

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,032

    Re: Fetching Specific Data and Sorting

    This should take care of that:

    Please Login or Register  to view this content.

+ 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