Take a free trial of Clear Books Or take a look at our new product Clear Books Micro

Export Projects Report

Question asked by Taras Vynnytskyy 5 years ago

Hi

Is there any way I can export projects report in excel? In P&L export tool is available, but cannot find this in projects report. Can it be enabled please? We run multiple projects and need the breakdown overview, without it we need to export each project in P&L and merge afterwards.

Thanks, Terry

3 Replies

A tip for the copy and paste is to press Control & A to highlight the full screen, then right click for Copy, then in Excel use the Paste special option of Match destination formatting. You will need to delete some of the extra rows at the top and bottom of the spreadsheet but it's a bit more workable.

Hi Taras,

I am afraid that it is not currently possible to export directly to Excel from the Project report as you can with many of the others. Currently, the only option I can suggest is copy and pasting the figures across into Excel. I am sorry if this is not the easiest option, but it does pull them across OK.

Many Thanks,

Chris

A tip for the copy and paste is to press Control & A to highlight the full screen, then right click for Copy, then in Excel use the Paste special option of Match destination formatting. You will need to delete some of the extra rows at the top and bottom of the spreadsheet but it's a bit more workable.

Thanks Chris, Thanks Ros,

Yes, copy-paste worked. With multiple projects it becomes messy so. It would be helpful to have this feature in the future.

Thanks again, Terry

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are