I have this enclosed workbook in which in Cell $H4 I want to insert a formula that will concatenate the value located in cell $B4 and pickup the content of the worksheet having the name as listed in Cell $B4 and get the content of the Cell $I$4 of that worksheet and place it in the the Cell $H4 of the Status Summary.
I tried the following:
Code: Select all
="="&OFFSET(INDIRECT("$H" & ROW()),0,-6)&"!$I$4"
Your help in achieving this would be appreciated.
Regards,
Chuck