In the Excel File I have named range (A2:F10)for ex "Order" in Sheet1,I use this on another worksheet Sheet2 .
In Sheet2 in cell A2 I put the formula =Order, but it displays only 1 value in the named range and not the full range of data (A2:F10)
Need help to resolve the #Value Error for the Named ranges, thanks
Bookmarks