In 3D ref. can non-contiguous sheets appear?

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3
(excluding sheet2 ?) If so, what would be the notation? Thanks
 
Drag the Sheet2 tab to the *right* of the Sheet3 tab,
OR
Drag the Sheet2 tab to the *left* of the Sheet1 tab.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3
(excluding sheet2 ?) If so, what would be the notation? Thanks
 
I'm not sure why you'd want to do this, but I used:

Insert|Name|Define
Names in workbook: Test1
Refers to: =Sheet1!$A$1:$F$1,Sheet3!$A$1:$F$1

I used a comma as my separator since it matched my windows regional setting list
separator.
 
Back
Top