Excel and MS project

Copy/Paste works quite well, as long as you make sure your columns align.

Another way is to open the Excel file from MS Project and use an import map. (if you open a file in MSP and choose XLS as file format, it will launch the import wizard automatically)

H.T.H.

If you want to view timephased information in MSP then you can use the Analyse Timephased data wizard. First you must select either Gantt Chart, resource usage or task usage view. Then either select a number of tasks or the whole schedule and open the view menu on the top toolbar. From the list select toolbars, analysis and then click analyse time phased data. This launches the wizard and from here you can make a number of selections.

Yes and no.

Some Project data is available for easy display (Task Name, Task Start, Task Finish, Resource Name, Resource Group).

Some Project data is available only using VBA (Assignment Notes).

Some Project data is simply not available.

What data do you want to move from Project to Excel or from Excel to Project? Will you do this once? Or often?

Hi,
You have two way for this
1- create Dynamik link between Excle and MSP
2- Create Macro with VB or Internal Macro in excel

Another solution, is to use Visual Reports. They make Excel or Visio outputs, which are PivotTable/PivotChart or PivotDiagram (You can also make PivotTables with export feature). They all use a kind of map or template, which will be a handy tool, when you’re going to repeat they same action.