Copying Usage Views to Excel

[Pratta]

Dear All,
Using MS Project Std 2003.
How do I copy a Task Usage or Resource Usage view to Excel.
I am sure I used to do this by 2 separate copy and paste operations; one for
the task data, and the other the timescaled data. But the I cannot
successfully Ctl/C and paste the timescaled data as separate columns?
I can do it copying and pasting one column at a time.
The contents that are pasted from multiple columns is concatenated , and it
is difficult to separate the data with a Excel Text to Columns command. It is
in a strange format in Excel after removing the h.
There must be an easier way.
Thanks

 

[JulieS]

Hi Pratta,

In a quick test, I was able to copy multiple columns of data from the
timescaled (right) side of the Task Usage view by selecting the column
headings. Click and drag in the column heading representing the bottom
tier of the timescale. Then copy and paste as usual.

Perhaps if you explained in a bit more detail the steps you are taking
to copy the timescaled data we can be able to help you better.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[John]

Dear All,
Using MS Project Std 2003.
How do I copy a Task Usage or Resource Usage view to Excel.
I am sure I used to do this by 2 separate copy and paste operations; one for
the task data, and the other the timescaled data. But the I cannot
successfully Ctl/C and paste the timescaled data as separate columns?
I can do it copying and pasting one column at a time.
The contents that are pasted from multiple columns is concatenated , and it
is difficult to separate the data with a Excel Text to Columns command. It is
in a strange format in Excel after removing the h.
There must be an easier way.
Thanks

Pratta,
If I may jump in, like Julie I had no problem copying multiple columns
of the timescaled data in either Usage view and pasting it into Excel.
However, unless you only need to do this export of data once or very
infrequently, copying and pasting is a very inefficient and
prone-to-error method. Have you tried using the "analyze timescaled data
in Excel" utility found on the Analysis toolbar? It will give different
results depending on which Usage view is used as the starting point.

If you need to do this type of data transfer on a regular basis, the
best way is through a VBA macro. If you don't know VBA, we can help you
learn it - if you are interested.

John
Project MVP