Quote Originally Posted by max8719 View Post
Lets say a company can appear in any cell within the ranges across the 10 sheets. Each range is a reference to a week and each sheet is a reference to a staff member. What i am trying to acheive is if any staff member duplicates the name of a company within the ranges excel highlights it as a duplication.
Hi pete i will attach the document later today. Thank you