+ Reply to Thread
Results 1 to 5 of 5

Excel beginner. trying to compile a summary sheet

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel beginner. trying to compile a summary sheet

    Hello,

    As a basic user of excel in the past I've been able to do the easy stuff, but i've been tasked with creating a time card/daily report for my employer and am stuck trying to get a summary sheet to calculate out.

    To start. My time sheet is made up of 7 days. (7 sheets) each day is set up with employee names (to be put in on a daily basis) and up to 5 different cost codes. The cost codes are manually entered for each day, and can and will change through out the week. I currently have over 25 cost codes (sheet 8) and im trying to have a summary sheet (sheet 9) that will automatically add the total hours for each cost code for each day. I have no idea what kind of formula to use to compile this information.

    I know that you guys will likely need more info. I'll be happy to answer any questions

    Thanks
    Dennis

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Excel beginner. trying to compile a summary sheet

    It would help if you attached a sample workbook with some example data in - it can be made-up data, but the file should reflect the arrangement that you currently have.

    Pete

  3. #3
    Registered User
    Join Date
    01-27-2014
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel beginner. trying to compile a summary sheet

    Sorry for the delay. I've had some other projects that became priority.

    So, here's the file with the basic setup. Im looking to be able to use page 9 as a summary sheet where I can have the hours from line 56 columns E-J (daily sheets)be automatically entered into their corresponding cost code.

    Eventually I'll be trying to "lock" some of the cells so information that needs to remain cant be changed on accident.

    Thanks
    Dennis
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-05-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel beginner. trying to compile a summary sheet

    Hi Dennis,

    I am not an expert but i was thinking if using HLookUp function can help here.
    Attached Files Attached Files
    Last edited by ROXI; 02-04-2014 at 05:30 AM.

  5. #5
    Registered User
    Join Date
    01-27-2014
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel beginner. trying to compile a summary sheet

    Perfect!

    Thanks Roxi. I thought that might have been the way to go, I just have zero experience with it and had no idea how to go about setting up the formula. Thank you for your help.

    Dennis

+ 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. Count data meeting certain criteria from multiple files and compile into Summary
    By Kettie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2013, 12:30 PM
  2. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  3. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  4. Need to Compile Data from Multiple Sheets to a new Summary Sheet
    By achandra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2012, 01:15 PM
  5. Compile a summary from multiple sheets under conditions
    By nikenis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2012, 05:10 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