HI,
i have a table that looks like this:

Name step 1 step 2 step 3 step 4 step 5 step 6
A 9-Sep-06 9-Aug-06 10-Oct-06 1-Nov-06 10-Oct-06 1-Dec-06
B 10-Oct-06 1-Dec-06 6-Aug-06 10-Oct-06 1-Jan-07 10-Oct-06


On another sheet, i would like to show what steps will be completed in
October, Nov, etc for each item without havign to renter the information

Name Oct-06 Nov-06 Dec-06
a Step 3 Step 4 Step 6
Step 5 -

b step 1 step 2
step 4
Step 6

Unfortunately, the steps are not sequential, they can happen in any order.
Additionally, there are about 40 steps so a series of IF statements is not
possible.

Thanks Emma