need a macro to compare two ranges in two different sheets

Hi,

I am relatively new to VBA macros. I am having two sheets, in one sheet I have a non-contiguous 20 rows range and in the other sheet I have a 20 row contiguous range. I need a macro which will compare data between the two ranges(one to one compare) meaning 1st row of the first range should compare with 1st row of the second range and if it matches then it should populate the adjacent column in the second sheet with true or false accordingly.

Any quick help will be greatly appreciated.

Thanks in advance!

Send a short sample of your data, this will help to customize the macro.
Are you sure you need a macro, a formula could work.

Else try

Please Login or Register  to view this content.