Thread: need to compair two excell docs and find the changes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111 robert111 is offline
external usenet poster
  
Posts: 1
Default need to compair two excell docs and find the changes

Yes - create a third large excel doc and in cell A1 put

=if(nameoffirstdoc!A1=nameofseconddoc!A1,"","X")

and copy across spreadsheet.

changes will be marked x


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570297

Reply With QuoteReply With Quote