+ Reply to Thread
Results 1 to 5 of 5

Need to dynamically show data as per criteria given

  1. #1
    Registered User
    Join Date
    03-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Need to dynamically show data as per criteria given

    Hi,

    Need urgent help from you all please...
    I have a work sheet where a huge number of employee details will be given.
    In the first sheet(Data) data will be given.
    In the second sheet(Search) at A3 "Joining Location" criteria,at B3,C3 "Joining Year" criteria(like people joined between 2001 and 2013),at D3,E3 "Age" criteria(like people of age between 30yrs and 40yrs) will be given.
    Based on the criteria resultant data will be poultated in the given format.

    Hope whatever i mentioned and the attached sheet will make sense. Request for your urgent help please.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-01-2005
    MS-Off Ver
    2007
    Posts
    368

    Re: Need to dynamically show data as per criteria given

    Hi,

    See attached file.

    I used the 'Advanced Filter' feature to meet your needs. Change the criteria range as you want.

    I hope it's ok!

    Elio Fernandes
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need to dynamically show data as per criteria given

    Hi,
    Thanks for your fast help. It worked quite good.

    But just another request. Can we enhance it such way that all the column for a particular row in the data sheet will show up.

    Thanks in advance for your help.

  4. #4
    Registered User
    Join Date
    01-01-2005
    MS-Off Ver
    2007
    Posts
    368

    Re: Need to dynamically show data as per criteria given

    Hi,

    See attached file.


    I just added a column with the header 'Row' in sheet 'Data' and I updated the 'ExtRng' in the module.



    Elio Fernandes
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2013
    Posts
    115

    Re: Need to dynamically show data as per criteria given

    Sorry Bro, I know it is against forum rules to reply to thread with a new question,

    However I dont know how to add an excel file in attachment

    I am facing a prob explained in latest issue.

    Can u pls let me know how i can solve this...

    Pls also explain how can i attach the file.



    rgds
    AT
    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)

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