Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How one can Extract sprint reports of different teams for each sprint using Excel VBA

Vaibhav Vaidya June 2, 2019

Hi,

As we know, we can directly export the jira reports through excel. But here I am looking for instead of manually export the reports for each individual team how VBA will be helpful to do this activity.

Lets say we have 4 different teams. So at the end of sprint, I want to capture ( Story number, Story Points ,Assignee) for each team and kept all these data in a sheet of excel.

After the next sprints ends, excel will automatically add new sheet to capture the same details of individual teams in the next sheet.

This is repetitive action. So that all the sprints data for all teams should be maintained in same excel.

How one can start with VBA to achieve this? Please let me know in detail as I have no pre-requisite of VBA.

 

Thanks 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events