View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Can I import data from MS Project into Excel or vice-versa?

I don't work with Project but I have Project 2003 installed.

I opened it and typed "excel" into help and found out you can link a project to
Excel data and export Project data to Excel.

See also the help items on linking and embedding objects from Project to other
Applications.


Gord Dibben MS Excel MVP

On Fri, 29 Dec 2006 15:47:00 -0800, OfficeGreenBean
wrote:

I am curious if there is a way to integrate a project plan with Excel. The
intent is to maintain a task list with milestones for all projects for each
team member to get a better snapshot of who has done what over the past
week/month/quarter and also current workload and then also be able to export
some of this data to MS Project to create a project plan.

I would appreciate any help or leads.

Thanks.