ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro (?) for comparing 2 Excel files/sheets (https://www.excelbanter.com/excel-programming/314588-macro-comparing-2-excel-files-sheets.html)

Ex`cited

Macro (?) for comparing 2 Excel files/sheets
 

I need to know if the exact word is in both Excel documents/sheets. Ca
anybody help to write any macro or is there another way?

It's all about databases with much data, so the way to use FIND menu d
not fit, I think... :(

Thanks!

Neriju

--
Ex`cite
-----------------------------------------------------------------------
Ex`cited's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27203


Frank Stone

Macro (?) for comparing 2 Excel files/sheets
 
hi,
not sure if it will help but try this site
http://www.cpearson.com/excel/duplic...#InOneNotOther
regards
Frank
-----Original Message-----

I need to know if the exact word is in both Excel

documents/sheets. Can
anybody help to write any macro or is there another way?

It's all about databases with much data, so the way to

use FIND menu do
not fit, I think... :(

Thanks!

Nerijus


--
Ex`cited
----------------------------------------------------------

--------------
Ex`cited's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=15673
View this thread:

http://www.excelforum.com/showthread...hreadid=272031

.



All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com