+ Reply to Thread
Results 1 to 2 of 2

searching multiple tabs for matching dates and extracting data to summarize on another ta

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    Calgary,Alberta
    MS-Off Ver
    Excel 2010
    Posts
    1

    searching multiple tabs for matching dates and extracting data to summarize on another ta

    I have a workbook I use to track time for projects. I can work on multiple projects on the same day so I have multiple tabs named Project 1, Project 2 up to Project 6. I have one tab called Daily Totals dedicated to summarizing my time by date for invoicing purposes. Both the project tabs and the totals tab have dates entered into rows A6:A37. I would like to write a formula or insert a function into the totals page to search the project tabs for a given date then add up all the hours from the hours columns C6:C37 for the given date. Column B is a description of the days work activities.

    Totals TAB........................ Project 1 Tab............................................... Project 2 Tab
    A...........B.................A..................B................... c................A..................... B.....................C
    6 Date.....HOURS.........6 Date.......work description......Hours.........6 Date..........Work Description......Hours
    6-Nov-13....9...............6-Nov-13....Tied Shoes.............1..............6-Nov-13..............sent e-mails.........8

    any idea's would be appreciated

    regards
    ProjectBri
    Last edited by ProjectBri; 11-22-2013 at 04:28 PM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: searching multiple tabs for matching dates and extracting data to summarize on another

    Attached your workbook.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    11-13-2013
    Location
    Calgary,Alberta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: searching multiple tabs for matching dates and extracting data to summarize on another

    Attachment 279691

    Here is the workbook. Thanks!

+ 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. [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
  2. Extracting data from multiple columns with multi value matching
    By Antagonizer82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2012, 02:59 PM
  3. Extracting data and summarize in time intervals
    By tessda in forum Excel General
    Replies: 0
    Last Post: 06-10-2011, 09:20 AM
  4. Extracting web data (a table) for multiple dates ?
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2010, 11:09 AM
  5. Extracting info from multiple worksheets to summarize
    By MrsHydrogeo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-18-2007, 11:55 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