Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Houston, Tx, USA
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Project 98 export cash flow to Excel

    In Project 98 (WinNT), how do I export a monthly or yearly cash flow to Excel?
    Guillermo

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project 98 export cash flow to Excel

    1. Click FILE, SAVE AS
    2. Choose Save As EXCEL,
    3. Click SAVE
    4. This Brings up "Export Format" Menu
    5. Choose "Cost Data by Task"
    6. Choose "edit" and check TASKS and RESOURCES
    7. Click "Task Mapping"
    8. Click on the 1st cell under "From Microsoft Project Field" and then Click the down arrow to select: cost, duration, early (or late) Start, early (or late) Finish, Name, Resource Names and Work
    9. CLICK OK
    10. CLICK Resource Mapping and Select:
    11. Cost, name, work, start, and finish
    12. Specify a Destination Worksheet name
    13. Click OK
    This will give you two WS in EXCEL. One with costs by Task for different time intervals and one with costs by Worker for different time intervals

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •