Collecting data monthly, so have 12 identical sheets. Each sheet has a data table and chart.
Want to print either data or chart of any month from wherever I am sheet-wise.
Used Sheet>Named Range and Expressions, Defined for each item per sheet as global per manual. As per manual, selected required item via Format>Print Ranges, Edit. Result is range on the active sheet is chosen, not the selected one.
Set Scope from Global to Sheet name. Format>Print Ranges, Edit. None listed.
So a bit of a charlie foxtrot. Any remedies ?