Macro/command to fill down based on last populated cell

Microsoft Excel 2010 - complete product...
March 21, 2016 at 19:52:40
Specs: Windows XP
Hi! I'm positively stumped on how to fix this issue: we use TFS for story management, and have recently gotten an updated version we're being asked to use 'out of the box'. As PM, I have a lot of analysis I do on our story backlog and a lot of reporting that needs to come from the backlog. Most often, I need to 'roll up' analysis from story level to feature level. Feature is not a field you can populate on a story, but you can create a feature and link the story to it as parent and child. In Excel of course this shows up in a tree view, with nothing on the rows containing user stories that tie it to a feature other than the initial structure of the download. Parent (feature) shows up in column 'title 1' for feature rows and 'title 2' is blank, for user stories 'title 1' is blank and story title is in 'title 2'. I desperately need to populate the title 1 field for all user stories with the proper feature. I will build out a little chart as example to post. Just needed to post this part immediately (though I'm on my phone) before I either cry or quit my job.

See More: Macro/command to fill down based on last populated cell

Report •

#1
March 22, 2016 at 08:00:56
Looks like this will come in two flavors - for most teams their stories will break out as above, some will have an Epic, then a Feature, then a Story (title 1, 2, and 3 respectively) and for reporting I would need epic and feature to populate on each line. Trying to add an example below, not working as I'd hoped. I'll keep trying!


Report •

#2
March 22, 2016 at 08:05:11
Trying to add an example below, not working as I'd hoped.

Can't help with a macro, but read this How-To which explains the use of the < PRE > tags in posting your data in theses forums.

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

#3
April 14, 2016 at 01:31:45
I'm positively stumped on how to fix the same issue: As PM, I have a lot of analysis I do on our story backlog and a lot of reporting that needs to come from the backlog. I needed to populate the title 1 field for all user stories with the proper feature as well. Thank you.

Report •
Related Solutions


Ask Question