Pull needed data from 'task backlog' to populate 'current sprint' sheet

[tek_9]

Hello excel gurus,

I have been working with formulas but I've hit a brick wall.
I hope someone can help me come up with a VBA/macro that will be able to do the following.

I have a workbook with 3 sheets: "current sprint", "user defined", and "backlog".
Please see the attached example file.

When a user chooses a sprint from the list in 'current sprint!C6' I would like it to grab data from every work item in the 'backlog' sheet that corresponds to that sprint. (column F:G) I would like it to display these items on the current sprint sheet. Specifically, I would like it to grab data in the 'work item', 'tasktype' and 'feature group' column from the backlog sheet and populate the 'current sprint' sheet for tasks that are assigned to the sprint defined in C6.

Appreciate any help on this.

Cheers,
Mike

[tek_9]

I've seen in other threads that you can copy past rows from one worksheet to another.
Would it help if the columns on 'backlog' and 'dashboard' were exactly the same?

Also, does being able to select the sprint in c6 make it increasingly difficult?

- M

[tek_9]

bump, no response.

btw, is this something that i could learn how to do in a professional excel VBA scripting class? or, is this type of thing something that excel can't handle?

thx

[arlu1201]

Right click on the Current Sprint sheet and select "View Code". Copy this code over -

Please Login or Register  to view this content.

[mike7952]

Another way

Please Login or Register  to view this content.

[tek_9]

>>arlu1201
You are awesome. Thank you so much. The code works like a charm.
Can I send you like a bottle of wine or something?

>>mike7952
Thanks for your reply also, however the columns seem to populate with the wrong data. (task type is filled with sprint #)