Compare two ranges and display equals in list
 

Hello,

I have a databook with 4 sheets, the first sheet has data in one rag
that i have to compare with ranges in the three other sheets, in cel
L,m,n i have to get the lst wth the equals in the ranges.

I have a button where i press and have to get the equals in th
following lists.

L is from sheet 1
M is from sheet 2
n is from sheet 3

can you tell me which VBA code i have to use to perform this actio

--
Message posted from http://www.ExcelForum.com

Compare two ranges and display equals in list
 

Please ask the question again. Be careful. what do you
mean by "L", "m" and "n"? what are you trying to compare?
do you already have a button? what does it do?

-----Original Message-----
Hello,

I have a databook with 4 sheets, the first sheet has
data in one rage
that i have to compare with ranges in the three other
sheets, in cell
L,m,n i have to get the lst wth the equals in the ranges.

I have a button where i press and have to get the equals
in the
following lists.

L is from sheet 1
M is from sheet 2
n is from sheet 3

can you tell me which VBA code i have to use to perform
this action


---
Message posted from http://www.ExcelForum.com/

.