If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel sheet creation??
Frank,
Thanks for replying... we use a report generating tool (access)that gets talks to the database - but the custom reports don't have all the information... I am creating this report for a manager - Basically - this is what she wants: employee: the project she is working on hours per month and YTD - all of these come from that report - but we need a rate we bill to each client per hour - which is determined by the total fee we invoice to each client... So what she would like for me to do if possible is a report/template where I get a drop down menu for each employee - then it would give me the projects - the number of hours he/she have worked on monthly and YTD create a formula that pulls from another sheet the amount invoiced/billed to client divided by the YTD hours worked on each project... Hope that helps... Again thanks for your time and help... --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|