can anyone help with copy-finding macro?
 

I have a huge problem.
I have a xls. file being created as an export from another program.
It has a number of worksheets with text data in 4 columns.
the task is to find copies of text in same columns of 2 sheets and do
that for all pairs of sheets.
the result i need is a new sheet with information what common objects
in same columns does each pair of sheets have.
for example :

sheet1 and sheet2 have:
text1, text5, text9 in column A
anothertext1, anothertext4 in column B

sheet1 and sheet3 have:
no duplicates in column A
no duplicates in column B

sheet2 and sheet3 have:
text1 in column A
no duplicates in column B


i'm not that so good in VBA, but i really need this to be done...
i will really appreciate your help


--
popovsky


------------------------------------------------------------------------
popovsky's Profile: http://www.excelforum.com/member.php...o&userid=25309
View this thread: http://www.excelforum.com/showthread...hreadid=388611