Dear NG:

Has anyone been able to get this 3-D Reference to work?

This is an excerpt from the Help file telling you what to do:

Name cells on more than one worksheet by using a 3-D reference
1.. On the Insert menu, point to Name, and then click Define.
2.. In the Names in workbook box, type the name.
3.. If the Refers to box contains a reference, select the equal sign (=)
and the reference and press BACKSPACE.
4.. In the Refers to box, type = (an equal sign).
5.. Click the tab for the first worksheet to be referenced.
6.. Hold down SHIFT and click the tab for the last worksheet to be
referenced.
7.. Select the cell or range of cells to be referenced.
I've followed the directions and the range (Tag_Number) IS added to the list
of "Names in workbook"
in the "Define Name" dialog box. In the refers to box is:
=January:December!$C:$C

The range however is not listed in the drop down box in the upper left
corner of the worksheets
and it does not work in formulas.

Anyone had any success with these types of ranges?

Any help you could pass along would be appreciated.

Thanks,

-Kevin