R
RSnyder
A suggestion:
If you know the duplication I would suggest doing a FIND
on all sheets at one time. It will pop you through each
sheet with that contains the value. If you're looking to
isolate what is duplicated and you're looking into a
particular column on each sheet, I would suggest doing a
COUNTIF function to get the count from each sheet. That
way you know what isn't and is duplicated.
For example, if you had 5 sheets with customer numbers on
each one of them indicating sales through 5 different
product lines and you wanted to know total sales by
customer. To put together the TOTALS sheet, copy all
customer numbers to a blank sheet from each of the other
sheets and then sort and delete the duplicate lines. Then
set up a formula for each sheet in each column starting at
column B like =COUNTIF(Sheet2!A:A,A1), =COUNTIF(Sheet3!
A:A,A1), and =COUNTIF(Sheet3!A:A,A1). The "A1" is a
reference to the cell on the new sheet holding the value
for counting the occurences on the subsequent sheets.
Duplicate this across the new sheet for every existing
sheet. This will tell you the sheets where the value
exists and how many times its found in column A on the
respective sheet.
This is all manual. To put code to it would take a lot
more.
If you know the duplication I would suggest doing a FIND
on all sheets at one time. It will pop you through each
sheet with that contains the value. If you're looking to
isolate what is duplicated and you're looking into a
particular column on each sheet, I would suggest doing a
COUNTIF function to get the count from each sheet. That
way you know what isn't and is duplicated.
For example, if you had 5 sheets with customer numbers on
each one of them indicating sales through 5 different
product lines and you wanted to know total sales by
customer. To put together the TOTALS sheet, copy all
customer numbers to a blank sheet from each of the other
sheets and then sort and delete the duplicate lines. Then
set up a formula for each sheet in each column starting at
column B like =COUNTIF(Sheet2!A:A,A1), =COUNTIF(Sheet3!
A:A,A1), and =COUNTIF(Sheet3!A:A,A1). The "A1" is a
reference to the cell on the new sheet holding the value
for counting the occurences on the subsequent sheets.
Duplicate this across the new sheet for every existing
sheet. This will tell you the sheets where the value
exists and how many times its found in column A on the
respective sheet.
This is all manual. To put code to it would take a lot
more.