Dear All,
attached are two result and data source sheets. For this question I'll request your attention to the values highlighted red in the 'Result Sheet'. These values for each corresponding PI Name marked yellow are got from their corresponding tables in the 'Data Sheet'. The values are obtained with help from the offset+indirect+match combination formula below.
= OFFSET(INDIRECT("[Data_Sheet.xls]SAA_CBA!$C"&MATCH(B3,'C:\bryen\040510\[Data_Sheet.xls]SAA_CBA'!$A$1:$A$51,0)+1),0,0)
Can anyone help me apply this formula to all the cells using a macro? This would help avoid typing the formula in each cell.
Thx for all help...
bryen
Bookmarks