Thread: [Solved] Complex Directory
View Single Post
 
Old 09-29-2016, 06:25 AM
Optional_karl Optional_karl is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2016
Posts: 1
Optional_karl is on a distinguished road
Thumbs up Complex Directory

Hello Everyone,

I am a business Analyst, and reguarly create 'Story Packs'. I'm looking for a way to build them automatically from excel csv data. I'm 99% certain it can be done, and i've got almost there using a directory mail merge wizard, but i want to know if the below is possible, and how i'd do it:

Essentially the pack should be laid out like below:

Feature 1
Story 1.1, Description 1.1, Acceptance Criteria 1.1
Story 1.2, Description 1.2, Acceptance Criteria 1.2
Story 1.3, Decription 1.3, Acceptance Criteria 1.3

Feature 2
Story 2.1, Description 2.1, Acceptance Criteria 2.1
Story 2.2, Description 2.2, Acceptance Criteria 2.2

And So on. There could be any number of features, and any number of stories within each feature.

I've attached an example of my data source: Gdrive link - inputs.csv

I'm quite handy with VBA, so if that's required, so be it!
Reply With Quote