Hi all
I'm trying to pull the value in cell J62 of another worksheet. The worksheet name is in B40 of the same worksheet where I have my formula. Essentially I am trying to pull the worksheet name and add it to the cell number to create a formula that pulls that value in another sheet. Here's the formula I'm trying but its not working:
=CELL("contents","'"&"B40"&"'!"&$J$62))
B40 contains the workbook name: "Fox Trails"
So I want the formula to evaluate as
=CELL("contents",'Fox Trails'!$J$62)
and return the value I have listed in J62 of the Fox Trails worksheet.
I don't have to use the cell function, I just thought that was easiest. I also tried
="'"&B40&"'!"&"$J$62"
but that just gives me the text 'Fox Trails'!$J$62
<tbody>
</tbody>
Thanks
I'm trying to pull the value in cell J62 of another worksheet. The worksheet name is in B40 of the same worksheet where I have my formula. Essentially I am trying to pull the worksheet name and add it to the cell number to create a formula that pulls that value in another sheet. Here's the formula I'm trying but its not working:
=CELL("contents","'"&"B40"&"'!"&$J$62))
B40 contains the workbook name: "Fox Trails"
So I want the formula to evaluate as
=CELL("contents",'Fox Trails'!$J$62)
and return the value I have listed in J62 of the Fox Trails worksheet.
I don't have to use the cell function, I just thought that was easiest. I also tried
="'"&B40&"'!"&"$J$62"
but that just gives me the text 'Fox Trails'!$J$62
<tbody>
</tbody>
Thanks