Search columns on multiple worksheets
In a workbook I have a worksheet for each month of the year. How would I be
able to automatically determine whether the entry currently being made has
been entered in the same column previously on any of the worksheets?
(Similar to €śFind€ť under Edit) If so, would it be possible to indicate the
previously entered data by highlighting each duplicate cell?
|