Hi, 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
Bookmarks