I have a workbook with 2 sheets work and summary.
I have defined the ranges in sheet work .
the summary is a consolidation of data from sheet work .
But when I make the formula from sheet summary , the defined name does not appear when doing the formula .
my question can defined ranges from a sheet be used in a formula in another sheet .
In same sheet define name works when I consolidate the formula but on another sheet in same work book.
Can someone advise or should I use table nomenclature
Bookmarks