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/