Results 1 to 7 of 7

Feeding multiple columns from one sheet into another while combining totals based 2 column

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    cincinnati, oh
    MS-Off Ver
    Office 365 Mac
    Posts
    4

    Feeding multiple columns from one sheet into another while combining totals based 2 column

    Ok, so I am a total amateur with Excel and I'm quite surprised that I've gotten as far as I have so far. Basically, I've created a time sheet that allows me to breakdown our employees tasks and the time allotted to each task. The tasks are in a drop down menu to be selected from. However, each task is also related to a specific project, which is also in a drop-down menu. Each task is alotted a percentage of time (i.e. 30%). Then that percentage is multiplied times the total cost per day to allocate the price/task of that day for that employee. So .30 x $261.40 = $78.42 for Selective Demolition (Task) for 1328 Republic (Project) for that particular day. Then I need to total all of the amounts on another sheet, since a task might be repeated for the same project multiple times. I'll need it to show the total spent on "selective demolition" for that week. I just want it to auto populate in another sheet so that I don't have to waste my time do the numbers manually. Trying to streamline some processes with this file.

    Screen Shot 2015-07-22 at 10.16.17 AM.png

    employee time sheets.xlsx


    I attached a screenshot of the current sheet. Please help!
    Last edited by BabyBair0708; 07-22-2015 at 12:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  2. [SOLVED] Combining multiple columns into one column without any blanks
    By Tuanfeng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2014, 04:37 AM
  3. combining multiple columns into column on new tab
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2014, 05:27 PM
  4. combining columns from multiple sheets into one column
    By lex1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2012, 02:45 AM
  5. Combining multiple columns into one column
    By Casper_DK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2011, 05:39 AM
  6. reposting: combining multiple columns into one column - enhancements
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2006, 11:20 AM
  7. [SOLVED] combining multiple columns into one column - enhancements
    By markx in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-16-2006, 11:15 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