you can put the sheet name in front:

=SMALL(Sheet5!Fri_10,1)



Or you make global scope names:

Regards

Claus B.

--

Small addition to the code with: ActiveWorkbook.

Will make it much easier to install formulas on the master sheet.

Thanks.

Howard