Hi, I need some help and advice please..

I have designed a resource pool in MS project purely to monitor staff movement interns of the amount of days / percentages allocated to daily tasks and projects

We have over 70 resources, and almost 100 tasks so far and I have been steadily inputting time against each resource.

My problem is I would like to upload all this data into a spreadsheet as I feel the information would be better displayed in a spreadsheet. Can you help!!!
I really hope this makes sense, your advice would be greatly appreciated.

The simple way to do it is open the Resource Usage view. You can then highlight and copy the left side and paste it into Excel. You can then highlight and copy the spreadsheet side and paste it into Excel. You will not get the column headers.

The more difficult way is to write a macro to export the data out.

I am using Project 2003. Maybe the newer versions have better tools.

Hi
You can define an export view and then export to Excel. You can then use this view as many times as you wish.
Hope this helps.
Tony(OTPM)

To Export Resources to Excel
File > Save as
Save as an Excel file
This will launch the wizard.
When given an opportunity, choose to "Use Existing Map"
Then choose the map Resources Export table map
Next, next til Finish.