duplicate entries accross a workbook?

  • Thread starter Thread starter Lianne
  • Start date Start date
L

Lianne

I currently have a workbook set up with various tabs, ideally id like to
find a way that when I am entering text, ie a surname in a cell it will
prompt me if there is the same name in another tab? all the tabs are the same
format ie names are entered in to the same column etc
I know it soundss more like a database but this is what I have been asked to
work with :-)
 
Hi Lianne

You could try the below..

--In the sheet where you make entries ; create a named range of your tab
names. say mysheets

--Suppose you enter your names in ColA. Select column A. From menu
Format>Conditional Formatting> For Condition1>Select 'Formula Is' and enter
the below formula
=SUMPRODUCT(COUNTIF(INDIRECT("'" & mysheets & "'!A:A"),A1))>1

--Click Format Button>Pattern and select your color (say Red) and Hit OK

--Duplicate entries will be highlighted..Does that work for you?

If this post helps click Yes
 
Back
Top