A
Anjali Lourda
Hi,
I've uploaded the excel sheet at this location
http://rapidshare.com/files/339230049/Test_SAMPLE.xls.html
The first sheet has the list of features in column B.
I2:W2 contain the Block#
This is used to depict which features are being covered in which block.
For eg. I5 and I6 show that Feature 1 and 2 are being covered in Block 1
In the second Sheet, Project Timeline, T8:T:19 show the iterations. each iteration can have one or more blocks within it.
Based on the blocks selected for each iteration, the dates are calculated in column R "Bug Fix".
I need a report in the third sheet which gives me the list of features covered in each iteration along with the date when that iteration will end.
for eg.
Iteration 1
01 Feb 10
Feature 1
Feature 2
Iteration 2
17 Feb 10
Feature 3
Feature 4
Feature 5
Feature 6
Feature 7
Can this be done using a combination of lookup, match, index, etc?
Or would I need to use VBA code?
Thanks a bunch for reading through this!
Regards,
Anje
Submitted via EggHeadCafe - Software Developer Portal of Choice
Access Modifiers
http://www.eggheadcafe.com/tutorial...-4e21-bd2a-cbcf05d20d5f/access-modifiers.aspx
I've uploaded the excel sheet at this location
http://rapidshare.com/files/339230049/Test_SAMPLE.xls.html
The first sheet has the list of features in column B.
I2:W2 contain the Block#
This is used to depict which features are being covered in which block.
For eg. I5 and I6 show that Feature 1 and 2 are being covered in Block 1
In the second Sheet, Project Timeline, T8:T:19 show the iterations. each iteration can have one or more blocks within it.
Based on the blocks selected for each iteration, the dates are calculated in column R "Bug Fix".
I need a report in the third sheet which gives me the list of features covered in each iteration along with the date when that iteration will end.
for eg.
Iteration 1
01 Feb 10
Feature 1
Feature 2
Iteration 2
17 Feb 10
Feature 3
Feature 4
Feature 5
Feature 6
Feature 7
Can this be done using a combination of lookup, match, index, etc?
Or would I need to use VBA code?
Thanks a bunch for reading through this!
Regards,
Anje
Submitted via EggHeadCafe - Software Developer Portal of Choice
Access Modifiers
http://www.eggheadcafe.com/tutorial...-4e21-bd2a-cbcf05d20d5f/access-modifiers.aspx