View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Breezy Breezy is offline
external usenet poster
 
Posts: 20
Default Duplicate entires in multiple tabs

I need something to show me if I enter a duplicate field in a tab in a
worksheet. For example; I enter a list of invoice numbers on a tab "10.27.09"
in col B. Each day, I add a new tab with that days invoices numbers listed. I
want to know if I have entered an invoice number on tab 10.27.09 and again on
11.2.09. I just want something that will highlight the field. Is that
possible?