I
i2meek
earlier at
http://www.microsoft.com/office/com...misc&mid=fb15f05f-9139-47bd-ad18-2260e597da2f
i was instructed how to paste-link and fill down using the "INDIRECT"
function. Now I need to fill to the right. I need to have this formula:
=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!E4")
in a row and then fill to the right having the E4 go to F4, then G4, H4 ...
How can I do this?
http://www.microsoft.com/office/com...misc&mid=fb15f05f-9139-47bd-ad18-2260e597da2f
i was instructed how to paste-link and fill down using the "INDIRECT"
function. Now I need to fill to the right. I need to have this formula:
=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!E4")
in a row and then fill to the right having the E4 go to F4, then G4, H4 ...
How can I do this?