Search for duplicates in workbook

C

cursednomore

I have a large workbook with several sheets that are copies of each other,
but with different data in each worksheet. Is there an easy way to search for
duplicate records within one titled column over several wroksheets?
 
F

Frank Kabel

Hi
not an easy one. Would it be possible to merge your data on one large
sheet?
 
C

cursednomore

I am tracking sales orders on a daily basis, and need to make sure that I do
not have the same order entered on different dates. I cannot merge all the
worksheets, because I am also tracking sales between different ranges. Each
sheet has a column titled "Order Number" and it is the same column on every
sheet. There will be approximately 50 sheets when I am done.
 
Top