The Target cell is ' Pal Summary!$E$7
i have a page named Admin which holds settings including sheet names (Admin!E7 points to a cell with the word "Pal" which is part of a sheet name).
i tried the formula below but keep getting the #REF error even tho when evaluated the formula looks good eg ' Pal Summary!E7
=INDIRECT("'"&Admin!E7&"' Summary!E7")
Any ideas ?
Bookmarks