noppojp said:...
The formula i wanna copy across about 40 more times is:
=IF(NOT($A$9=""),INDEX('F:\directory\[Resource Allocation Planning.xls]Resource Allocation Plan'!2:1229,MATCH($A$9,'F:\directory\[Resource Allocation Planning.xls]Resource Allocation Plan'!$A:$A,0),90),"")
i basically want to add 40 more columns so that more projects can be added and time can be tracked to them.
i highlited the cell with the above formula, but the 90 will not change to 91 as i wish it to. Everything else in the formula should stay the same.
ANY IDEA what i can do to enable this final 90 to change to 91, & 92, etc.
...
Peter_SSs said:noppojp
With the formula as it is, I can see no reason why the 90 would change as you copy the formula across - it it just the number 90.
I haven't checked out the whole formula but if it starts in K10 and you want the 90 to increase by one each time you drag the formula one column to the right, then I suggest that you change the formula in K10 to this:
=IF(NOT($A$9=""),INDEX('F:\directory\[Resource Allocation Planning.xls]Resource Allocation Plan'!2:1229,MATCH($A$9,'F:\directory\[Resource Allocation Planning.xls]Resource Allocation Plan'!$A:$A,0),90+COLUMN()-COLUMN($K10)),"")
Now try dragging it across.