Find same context in to dif. worksheet

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi

I have a workbook to worksheet. The 2 worksheet have the same colum called
"assetnumber" but not necessary the same number. What I want is a makro that
finds the cells where the assetnumbers are the same.

Thanx in advance.

Brian
 
How about a couple of formulas in adjacent cells:

=isnumber(match(a1,sheet2!b:b,0))
will return True if A1 matches any cell in column B of sheet2.

And
=isnumber(match(b1,sheet1!a:a,0))
will return True if b1 matches any cell in column A of sheet1.

Drag the formulas down the column and apply data|filter|autofilter.

Then filter to see the similarities or differences.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 97 search macro help please 4
best way to automate deleting records and adding filters in a quer 3
Excel Highlighting duplicates 0
macro to control tabs (different worksheets) 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Combine three InputBoxes into one? 7
Allow macro to work for a group of cells but not the other cells 7
Compare two worksheets in the same workbook and highlight difference 7

Back
Top