Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display conditional formatting if cell value equals an integer | Excel Worksheet Functions | |||
COUNTIF a value within a range equals any value in an array/list | Excel Worksheet Functions | |||
if specific value from list A equals one of the values from list b... | Excel Worksheet Functions | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) |