Good afternoon all,

I'm trying to search a set of 9 workbooks for duplicate reference numbers. Is there any way i can search all workbooks at once? for example i have 9 workbooks, each workbook has 12 tabs. I would like a formulae that searches all 9 workbooks and tabs for duplicate reference numbers.

thanks very much

Ryan