compare multiple worksheets for duplicates

[ellac]

Hi everyone, I am trying to post this message again.

I need to compare multiple worksheets and find duplicates. When the duplicates are found they need to automatically be copied to a new worksheet in the same workbook.

That worksheet will then be password protected.

Can anyone help me, I need to finish this today.

Thanks so much for all the input.

 

[ellac]

I paste in the formula and it just basically does nothing.

We have till 1:00 this afternoon.

Thanks

 

[clipro]

check the names of the sheets - in the formula I named the sheet Sheet 1, Sheet 2 etc but if Your sheets are with different names you must change the names in the formula

check the address of the cells I use the address that you gave me - A1, A2 etc but if you use different address you must to change it in the formula

btw do we try to find all duplicates i.e. is it possible one data to be on Sheet 2 and Sheet 3 but not in Sheet 1?

 

[ellac]

Still not working.

 

[clipro]

check the formatting of the cell

check the separator in the formula on my PC it is ; but on yours it could be only ,

i check the formula again and it works on my PC

 

[ellac]

I keep trying it and it just puts the formula in the cell as if it is text it does not even give me an error. I have never had this happen to me.

I don't know what to do.

 

[ellac]

Any luck with the duplicates copy question?

I will repeat the question once more. I need a macro that compares sheets in a workbook and copies duplicates to a new worksheet in the workbook.

Please Please Please help.

 

[Von Pookie]

Please see:
http://www.mrexcel.com/board2/viewtopic.php?t=126944