Thank you Sergey, that works. Now I need to make it generic :)
That means that if the formula is in cell S10, the formula should be =INDIRECT("'" & S7 & "'!D8"). (The name of the worksheet is always in row 7 of the same column where the formula is).
I tried to obtain this cell's column by CELL("col"), but that gives the column *number*, not the letter. Do you know how to obtain this column's cell letter?
What resources do you recommend to become proficient at VBA (for Excel).
Thank you.
Alex
>Check INDIRECT() function
>
>=INDIRECT("'" & R7 & "'!D8")
>
>
>>I need that a cell in one Excel sheet (the target sheet) gets its value from a different cell in another Excel sheet (the source sheet) in the same workbook. The name of the source sheet is in a known cell of the target sheet.
>>
>>The situation:
>>Cell R7 of sheet X contains the string "May-06" (without the quotes).
>>Cell R8 of sheet X needs to get its value from cell D8 of sheet "May-06".
>>
>>Similarly:
>>Cell Z7 of sheet X contains the string "Feb-07" (without the quotes).
>>Cell Z32 of sheet X needs to get its value from cell D32 of sheet "Feb-07".
>>
>>In VFP this would be a cinch, but I don't know how to do it using Excel functions or Visual Basic for Applications.
>>Alex