Hoo boy...I bet this can be done with code. Perhaps try the Excel programming forum just below this. My coding abilities are rusty as hell, but I bet there's someone there that can steer you right.