Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specialized Spreadsheet
Anybody want to tackle a special request for a specialized spreadsheet
function? I need a way to track persons progress on a project. for example, they have 2080 hours in a work year. I need to account for holidays and weekends then if they are what ever project they can charge to. For example if they have 500 hrs on one project, 300 on another etc, planned days off and vacation it should project their time etc. My office e-mail is -- Michael Gomien |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specialized Spreadsheet
Do you use MS Project. You can write macros in MS project that wil export the data into an excel worksheet. the do your tracking from excel. Let project count the days and holidays which will simplifiy the work in excel. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=196709 http://www.thecodecage.com/forumz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
specialized formatting | Excel Worksheet Functions | |||
Specialized custom number format | New Users to Excel | |||
Specialized search engine for Excel | Excel Programming | |||
Specialized Cell Formatting | Excel Discussion (Misc queries) | |||
How do I link specialized reports in excel? | Setting up and Configuration of Excel |