Display report / summary based on data in two worksheets

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preserving cell validation on worksheets post data merging 1
Conditional format that higlights differing data on two worksheets 3
Formula for transferring data in rows to columns on two different Worksheets 1
Display a sequence of cell values based on the week 0
how to highlight changes in my data from one block of cells toanother block of cells? 1
Display a sequence of cell values based on the week 1
Pivot table - show monthly data based on start/end date data 0
How do I retrieve data based on multiple search criteria? 0

Top