Search for duplicates in workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
not an easy one. Would it be possible to merge your data on one large
sheet?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy rows from a sheet with duplicates in a column to a wor 1
Excel? How to copy sheet in workbook w/o having reconfirm cell nam 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Duplicates 2
how to find duplicate entry in one sheet and in workbook 1
Merge Multiple workbook sheets into one workbook 0
Paste Values in linked Cells Only 4
Removing Duplicates to another sheet 1

Back
Top