I'm trying to eliminate duplicate numbers across several worksheets. When I hold down the CTRL key and highlight 4 worksheets, then highlight the cells I want to validate, the validation key is grayed out. Can this be done??
Thanks