+ Reply to Thread
Results 1 to 1 of 1

Auto filter input box require

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Auto filter input box require

    Dear Friends,
    In my database I want to filter districts and talukas as per my requirement. I have created a macro for it but it requires to create several macros for all items which is very laborious job. I wish to avoid it by creating a input box for the item to be filter so that I have not create a separate macro for each item. In my database I want to create auto filter macro for 'District' and 'talukas' column 'h and i'. I want to create a list of items to select for filtration as follow:
    There are 35 districts and about 350 talukas in it for which I have to create a auto filter macro that means I have to create about about 400 macros for it which I want to avoid.
    Conditions:
    1. District: If I want to filter only by district and not taluka then the input box I have to select the name of district and the taluka input box will be empty. This macro will give me a output of district only.
    2. In taluka column I have created a dependent drop down list for districts. That means if I select district 'Nashik' then the talukas of Nashik will be display.
    For taluka macro:
    If I want to filter the taluka 'Nashik' from Nashik district then in input box I have to select 'Nashik' in district input box and 'Nashik' in taluka input box. The result will be the Nashik taluka in Nashik district only.
    Please help me to solve this problem.
    Thanking you in anticipation.
    Mukesh
    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. input box for auto filter
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2013, 06:17 AM
  2. Auto filter based on input
    By AUSSIEHEDGE in forum Excel General
    Replies: 0
    Last Post: 02-20-2013, 12:32 AM
  3. [SOLVED] application input box return different date formats leading to wrong resutl in auto filter
    By shaukat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2012, 09:52 AM
  4. Macro to Auto Filter by Input Box DATES ?
    By Originalgoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2010, 01:00 AM
  5. Apply Auto Filter Based on Date Input by User
    By ELDAN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2010, 09:07 PM

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