Populate table based on 3 inputs

Hi,

This is a cross topic and I am posting it here as I think this is the right forum than the one I posted before. Please reply to the original one by clicking the following link so that it will avoid watage of time.

http://www.excelforum.com/excel-work...ut-values.html

Below is the detail I posted in the link above :

I need a formula or macro to populate a table in a sheet based on the inputs from another sheet.

Below is my requirement :

I need to calculate the resource availability using the 3 inputs in sheet1 as below :

Tester, Start date, Stop date
Tester 1, 8/20/09, 8/22/2009
Tester 2, 8/21/09, 8/23/2009
Tester 1, 8/25/09, 8/26/2009

In sheet 2, I have a table as testers in rows and date as in column.
..................... 8/20.......... 8/21.......8/22…….

Tester 1............T .............T...........T
Tester 2...........T............. T
.
.
.

I want to populate a value(Say T) based on the start date and stop date given in sheet 1 for each tester.

Please see the attached file for example. I populated manually the value T based on values on sheet 1. I want to know how populate this value T automatically based on formula or some other macros.

There are more than 25 testers and the start date and stop date change dynamically. Based on this input if the sheet 2 is automatically populated, then I can easily know the available dates for a tester to make further assignments. That’s why I am looking for a formula to populate automatically. Please note that same tester can be assigned to multiple test cases.

Please let me know if you have questions. Thanks in advance for your help.

Senthil