I would like to copy the task usage view and grid out to excel. Go into project select the Proposal Task Usage view, Copy and paste into excel cell a2, I would then like the code to go back to the active project select the grid and format the time scale to years and months copy the grid and paste into excel d2.

Can someone automate this?

Many thanks in advance.