is it possible to create a drop down menu where additional information can be added then tallied up in a separate table?
I would like to create a menu representing "tasks" where an amount of "time" can be designated per menu for my employees to select and fill. I would like this information to then be tallied elsewhere so I can keep track of our efficiency.
I've attached the excel file to give a better idea of what i'm trying to accomplish.
I'd really appreciate any help or input guys!
Hi cubbymonkey,
You can have another Drop down just as you have for the tasks.
For example, where the '9' is.
Is the issue trying to collect many amounts of time for various tasks & adding them together?
Remember you are unique, like everyone else
Hi noboffinme, Thanks for the reply. I've uploaded an updated version of the file. As you'll see, there's a budget on the second tab that I would like to relay information into.
There's a "time" input beside each "task" drop down menu, I would like these inputs to be added up underneath the same category on the budget tab.
For example: If I work Monday, Tuesday and Wednesday doing tiling.. I would like the budget to reflect those accumulated hours (throughout the week) nested under "tiling".
Can this be done?
Thanks once again
Hi and welcome to the forum
This is a bit long-winded, but try this on the summary sheet, copied down (not sure which column you want to put it in)...
=SUMIF(Biweekly!$D$13:$D$56,Budget!$A3,Biweekly!$E$13:$E$56)+SUMIF(Biweekly!$F$13:$F$56,Budget!$A3,Biweekly!$G$13:$G$56)+SUMIF(Biweekly!$H$13:$H$56,Budget!$A3,Biweekly!$I$13:$I$56)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi cubbymonkey,
You can do this using the SUMIF Function.
Have a look at some examples & come back to me if you're stuck.
Cheers
Thank you both very much, that was exactly what i needed. So happy that I joined your forum
Happy to help and thanks for the feedback
For future reference, if your question has been answered, please use the THREAD tools (near the top of the page) to mark your thread SOLVED - it helps keep things neat and tidy
(I will do it for you this time)
Hey guys, Not sure if I should create a new thread or not, but I have a separate question relating to this summary workbook. Is it possible to have my summary page draw hours from an individuals separate timesheet workbook, but only draw hours that relate to the job via a location selection drop down?
My idea is to have a project summary workbook per job that's at hand. Employees will fill out their own timesheets in a separate workbook, then each project summary will draw relative data from their timesheets. I need this to work for multiple employees and jobs. Can this be done?
Last edited by cubbymonkey; 12-27-2013 at 06:17 PM.
Just for future reference, you should try and avoid using merged cells if at all possible - they create nothing but problems!! (for instance, "day of week" is in row 11, but "task/Time" is in row 12...this creates havoc when using formulas)
Something like this in your master WB (for row 16 cells), copied down and across will get you started, I think. You will just have to make a small adjustment for the merged cells...
=INDEX('[employee-timesheet (1).xls]Biweekly'!$A:$I,MATCH($A16,'[employee-timesheet (1).xls]Biweekly'!$A:$A,0),MATCH(C$11,'[employee-timesheet (1).xls]Biweekly'!$A$11:$I$11,0))
and then this for row 17 cells...
=INDEX('[employee-timesheet (1).xls]Biweekly'!$A:$I,MATCH($A16,'[employee-timesheet (1).xls]Biweekly'!$A:$A,0)+1,MATCH(C$11,'[employee-timesheet (1).xls]Biweekly'!$A$11:$I$11,0))
Thanks for the reply Fdibbins,
I'm a little confused as to which cell I should be pasting this formula into?
Whats the significance of using A16 instead of A13?
How do I use this formula for multiple workbooks and employees?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks