Consulting

Results 1 to 5 of 5

Thread: Solved: Autofilter using date

  1. #1
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location

    Smile Solved: Autofilter using date

    Dear friends i have have a worksheet with data which has daets ranging for many year. based on user input by month is it possible to filter it?
    for example if the user specifies a period may 2008 to oct 2008 then it should fetch all these monthly data in respective sheets. is it possible?
    Thanks in advance
    Regards

  2. #2
    VBAX Mentor anandbohra's Avatar
    Joined
    May 2007
    Location
    Mumbai
    Posts
    313
    Location
    what about showing them on one sheet only with the given criteria
    try this file.
    Put your data in sheet named database (start with range A1)
    now run the query in sheet named query
    press the Run Query button & see the records qualifying your query
    Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
    Practice this & save time of others in thinking for unsolved thread

  3. #3
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location
    Dear anand
    I am not able to run your code, but after reading the code this is not exactly what i watn,
    in my case the i have a user form from which i will be getting input as time period e.g may 2008 to oct 2008 , now i want all the months betwwen these two(including these) to be on separate sheets. hope you got my point

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Can you post the workbook so as to save us time?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location

    Smile file attached

    Dear xld
    i have attached the sample sheet. using the column date the user will select the period and various sheets for each month will be generated between that period.
    regards,

Posting Permissions

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