+ Reply to Thread
Results 1 to 4 of 4

Filling multiple cells based on condition

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Filling multiple cells based on condition

    Hello!
    I am trying to simplify my weekly time sheets and cost codes as well as stream line that information to my budget (the budget is not included in this question). In the attached workbook, I have 3 sheets. Sheet John_Smith_Daily is where I would put one employee's daily time into the correct cost code category. John_Smith_Timesheet_BLANK is what my weekly timesheet looks like before any data and John_Smeeth_Timesheet is what I would like for it to look like when all of the data is filled in. Now on to my question:

    I would like to enter a formula into John_Smith_Timesheet that would parse John_Smith_Daily and add all hours worked and cost codes for a given day. I do not want to include cost codes that have empty cells. Is this possible? My John_Smith_Timesheet is somewhat dynamic considering all I have to do is enter the week ending date and it fills in the dates for the week for me. I would ultimately like to enter any date and the worksheet would fill in the cost codes and times accordingly.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Filling multiple cells based on condition

    In E7:

    Please Login or Register  to view this content.
    confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down

    in F7:

    Please Login or Register  to view this content.
    confirmed with just ENTER and copied down.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    05-08-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Thumbs up Re: Filling multiple cells based on condition

    Awesome! Thanks a lot!

  4. #4
    Registered User
    Join Date
    07-03-2011
    Location
    Mumbai, India
    MS-Off Ver
    2007
    Posts
    18

    Re: Filling multiple cells based on condition

    Dear NBVC,
    If the date columns in John_Smith_Daily sheet has characters in place of numbers, how can those cells be recalled in John_Smith_Timesheet_BLANK sheet in F7 cell and further down?
    sfshah

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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