View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
popovsky[_8_] popovsky[_8_] is offline
external usenet poster
 
Posts: 1
Default help me out with this - it's killing me..


I have a huge problem.
I have 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
no common objects in column C
no common objects in column D


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=388985