In Excel 2003, I have a user who would like to prevent duplicate product
numbers from being entered on any of multiple sheets in a file. Since
conditional formatting, countif, and vlookup don't work across a 3-D range,
the brute force method is doing multiple lookups, countifs, etc, one for each
sheet, for each product, on each of the sheets. However, these files are
already massive & slow (at least on our machines!), and I'd like a better
method. I'm willing to do it with VBA if that might be the way to go. Any
ideas out there? Thanks!