+ Reply to Thread
Results 1 to 3 of 3

Unable to Fetch Data Based on Selected Date

  1. #1
    Forum Contributor
    Join Date
    07-15-2015
    Location
    Kolkata
    MS-Off Ver
    2010 & 2013
    Posts
    303

    Unable to Fetch Data Based on Selected Date

    Hi All,

    Any one please help me to find out where i have done a mistake in this code. Because, this code is unable to fetch the data based on selected date.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Unable to Fetch Data Based on Selected Date

    Hi,

    Sorry, I can't help with the macro. I recommend consolidating all your data in one sheet and then us a Pivot Table with Slicers to achieve the same result.

    Attached is a modified version of your file.

    Hope this is works for you.

    Cheers
    Attached Files Attached Files

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Unable to Fetch Data Based on Selected Date

    This file contains a SUMMARY worksheet created by formulae. Each worksheet for the persons Adam Birendra etc has been listed entirely on the summary worksheet. Filters have been attached so that you can sort your data by name, date etc. Columns with merged cells for headers will only allow filtering on one of the sub headings as only 1 sub heading will be shown.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Need help to fetch data from other sheet based on Resource Name
    By Sanjibghosh in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-26-2016, 04:22 AM
  2. Replies: 3
    Last Post: 04-07-2016, 01:15 AM
  3. Replies: 8
    Last Post: 02-09-2015, 11:52 AM
  4. Unable To fetch Data
    By vipul520 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2013, 05:16 AM
  5. Excel 2007 : How do I fetch data based on conditions
    By fabtshow in forum Excel General
    Replies: 6
    Last Post: 06-03-2012, 07:48 PM
  6. Fetch data from another sheet based on a filter value
    By jrule in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2011, 12:38 PM
  7. Fetch values based on date
    By aravindkb7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2010, 08:41 AM

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