Skip to content

Filtering and export to excel

Christian ViddalMember for 17 years
Created
3
2
0
Hi,

Was wondering if someone could help me with a task regarding exporting.

I want to filter out all the activties due in one week and export it to excel together with all colums. I am sitting in Release:6.2(terminal server)

Appreciate if someone could explain it step by step as I have never done exporing to excel before but I have heard it is possible.

Thanks
Christian

3 replies

Oldest first
  1. 0
    Arnold Puy ·
    Hi Christian,

    You can simply go to Project Menu --> Resource Assignments, try to display all the columns you required by simply right click --> Columns --> Customize. To filter the One (1) week look-ahead try these parameters:

    (Any of the following)

    Where:      Start “is within range of” DD DD+1WK
    Or:      Remaining Early Start “is within range of” DD DD+1WK

    When done, go to Edit --> Select All and then right click copy and paste it to Excel sheet.

    Or you may try to go to File --> Export --> Spreadsheet - (XLS) and follow the window wizard.

    Regards,

    Arnold

  2. 0
    Christian Viddal ·
    Perfect, thanks a lot!

  3. 0
    Arnold Puy ·

    You are welcome..

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?