In cell A5 on the Summary worksheet, I have added the value SERVERONE Next to it, in cell B5, I would like a formula that uses the value in A5 to display the value of G7 in the worksheet of the same name (SERVERONE) I could manually use ='SERVERONE'!G7 However I would like this to be dynamic, so I can easily add more worksheetsHi Since 36 you can insert a field Sheet Name in a cell Activate the cell to be in Edit mode (eg Doubleclick in the cell) , ;Http//wwwcontexturescom/30excelfunctionsin30days30xl30dhtml Use the CELL function in Excel to get details about the cell format, location and contentsTh
1
