Thread: Find Macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jerry[_22_] Jerry[_22_] is offline
external usenet poster
 
Posts: 3
Default Find Macro


"Gary L Brown" wrote in message
...
Run 'SearchFinder'. It is an adaptation of something Mr. Manville wrote
about 7 years ago.

hth,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was
this
Post Helpfull to you?''.



When it asks you what you are looking for, put *-s-* as the searched for
criteria....



That worked really very well.

Now I have 2 different worksheets 1 & 2 that will have some cell data that
is the same. I would like to compare the cell entries of both sheets for a
match. For every one of the entries not found in sheet 2 that are in sheet
1, I would like to write them to another sheet. For everything not found in
both sheets, write them to another.

Thanks.