duplicate entries accross a workbook?
 

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 :-)

duplicate entries accross a workbook?
 

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
FormatConditional Formatting For Condition1Select 'Formula Is' and enter
the below formula
=SUMPRODUCT(COUNTIF(INDIRECT("'" & mysheets & "'!A:A"),A1))1

--Click Format ButtonPattern 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
---------------
Jacob Skaria


"Lianne" wrote:


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 :-)