Also, since global

scope isn't required to use the name in formulas then it's just NOT

'best practice' to give them global scope!
--

Garry

This is why I thought it was better/easier with a Global scope, and I understand you reason for best practices.

=SMALL(Mon_3,1) - Scope = Sheet

=SMALL(Sheet5!Mon_3,1) - Scope = Sheet + manually add sheet name

=SMALL(Mon_3,1) - Scope = Global

First formula errors.

Second formula is extremely tedious adding sheet name, but works fine.

Third formula works fine and is no more effort to enter than first formula.

Frustrating to me is the layout of data on the Mon to Fri sheets has changed and now a simpler formula makes more sense.

=IF(Mon!D3="","",Mon!D3)

Which can be pulled down and across so is much easier/quicker to install.

Howard