duplicate data over 10+ spreadsheets

o

New Member
Joined
Apr 5, 2002
Messages
5
I have about 12, 13, 14ish sheets where there's a list of items (Paper, Paper Clips, Staples, Tape and so on) in column B in each. These will occasionally have duplicate entries in themselves (in the very same columns on the very same sheet);or on another sheet in the same Excel file.

I have seen on numerous websites, including this one and the forum, how to quite easily use Conditional Formatting to (for example) highlight in bold red duplicate entries on the same list in the same sheet; what I need to do is cross over between this and compare the data being entered into all of these lists.

How do I do this?

(I've guessed at trying to name all of the lists' entires in a range called Items, and then applied conditional formatting to all, hoping that if things are in the same Range, perhaps it would cross check like that? But no, this doesn't work unfortunatly... so here I am :))

Thanks to all who try to respond to my desperate Excel-illiterate pleas for help :wink:
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top