excel sheet creation??

[tico31pl]

I need some help - I need to set up/create a template on excel for tota
hours that each employee works on a specific project... I get some o
the information from access (monthly hours & YTD hours) - I need t
then determine the rate for each project (amount billed/number o
hours) from another spreadsheet - then import the amount billed to eac
client from submitted...
Any suggestions on how to set this up - since I have to do this for 1
employees each month??

thank

 

[Frank Kabel]

Hi
if you already have some of your data in Access why not use Access for
this?. This sounds more like a databse application.
If you still want to do this in Excel you may procide some more
specific information:
- exact structure of your data
- how you want to cxreate reports
- etc.

 

[tico31pl]

Frank,
Thanks for replying... we use a report generating tool (access)tha
gets talks to the database - but the custom reports don't have all th
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 - al
of these come from that report - but we need a rate we bill to eac
client per hour - which is determined by the total fee we invoice t
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 m
the projects - the number of hours he/she have worked on monthly an
YTD create a formula that pulls from another sheet the amoun
invoiced/billed to client divided by the YTD hours worked on eac
project...
Hope that helps...
Again thanks for your time and help..

 

[Frank Kabel]

Hi
I still think you should add thise functionality in your database.
Otherwise you have to store all the information in Excel also.
So you either have to import specific date from your database into
Excel or go the other way around:
- add the information in yourdatabase
- create additional reports in Access

 

[tico31pl]

thank you...
one question in regards to setting it up in access...
the report writing tool gets the data from the data base and only whe
i run a report the tables are populated otherwise the queries, reports
tables are empty...

can you point me to point where I can intercept this data??
(tables/reports) set up my own queries and generate my own reports???
again thanks for all your help and time..