Results 1 to 6 of 6

Display data by searching in multiple sheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    zurich
    MS-Off Ver
    Excel 2010
    Posts
    99

    Display data by searching in multiple sheet

    Hello Everyone!

    In my attached spreadsheet, I want to display data like in sheet "Template"
    i.e. Data should be populated automatically in column B, C, J, K, L by searching data in respective created date sheet. (if not found, put zero in all columns)



    -->Please note that multiple sheet (ie. 01-Dec-2013, 02-Dec-2013) contain data of different date in column "Download_DT".

    that means if you check work sheet (01-Dec-2013), the "Download_DT" column contain date like 01/12/2013 20:34
    27/11/2013 20:34
    28/11/2013 20:34

    So, formula will choose only data of correct date (i.e. 01/12/2013 20:34).


    Due to space constraint, I am not able to create multiple sheet with respective date.

    Advance thanks for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro error while searching data in multiple sheet
    By sanyaa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2013, 12:34 PM
  2. [SOLVED] Code for searching multiple worksheets and copying matching data to 1 w/sheet
    By lambi15 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-09-2013, 07:58 AM
  3. Replies: 1
    Last Post: 03-24-2009, 04:35 AM
  4. Searching for data across multiple sheets and copying to one main sheet
    By truedonk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2008, 08:13 AM
  5. [SOLVED] How do I display data from multiple worksheets in a summary sheet.
    By stardust in forum Excel General
    Replies: 1
    Last Post: 03-18-2005, 09:06 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