Geting data out

Resolved · Low Priority · Version 2003

Geting data out

Lisa has attended:
Project Intro Intermediate course

by - delegate Lisa [2 posts] (2008 Jul 10 Thu, 15:55) Reply

How do you export different views of the data?

Version	Date	Location	Places available	Book	Next place rate:
Project Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 24 Mon + 25 Tue	Southwark	4	book now	£475	£485
2007	2008 Nov 27 Thu + 28 Fri	Bayswater	0	FULL
2007	2008 Dec 8 Mon + 9 Tue	Bloomsbury	0	FULL
2003	2008 Dec 9 Tue + 10 Wed	Bayswater	6	book now	£335	£365
2007	2008 Dec 11 Thu + 12 Fri	Bloomsbury	1	book now	£490	£495
2003	2008 Dec 18 Thu + 19 Fri	Southwark	7	book now	£345	£399
Full Schedule: See all 55 Project Intro Intermediate course dates. Bookings currently available until 26th November 2009.

RE: Geting data out

by - trainer Andrew platinum contributer [513 posts] (2008 Jul 17 Thu, 11:40) Reply

Hi Lisa

a fast way to get data out of a Project table is to click on the square in the top right corder (select all button - above the row numbers and to the left of the column headers). From the edit menu choose copy task and then in Excel choose Edit > paste.
If you don't want the summary tasks to come along with the data, in Project go to Tools > Options > View and remove the tick from the option to show summary tasks. Back in the Gantt chart you will see only tasks (not their summaries). These can now be copied to Excel.

Hope this helps - let us know if you need any further information.

Kind regards,

Andrew