compare 2 tables

Hi there! I am trying to do this way (https://www.excel-easy.com/examples/compare-two-lists.html) to compare in VBA but I can not get the same result as when I try it manually.

Hi, I am stuck on one point. I want to compare directly 2 VBA tables, I even do not know if possible: here code: test1 = sheet(1).range("B2:f2") test2 = sheet(2).range("C10:G10") I want to compare test1 and and test2. Can I do directly : if test1 = test2 then do something endif It seems it...

Hello everyone, I am having a problem and I'm a newbie with excel so looking for some help! I need to compare two sets of data and find a match, for example... I need to compare User 1 Row with each Row of Group B to see if User 1 picked User 6 and User 6 also picked User 1 for a positive...

Hi guys, I've made a couple of example tables to explain my problem (see tables below). I'm struggling with the following: I have two sheets. Sheet T1 and sheet T2. I want Excel to take the data from column C from sheet T2 and put it into column D of sheet T1 to form sheet T3. So Excel...

Hi all! I am working with two different data tables. Data Set A has 2 columns and Data Set B has 4 columns. The 2 columns in Data Set A are the same information as the first 2 columns in Data Set B. I am looking for some guidance as to how create a macro that finds exact matches between A & B...

Hi, sorry I've been banging my head against my desk and screen as i just can't seem to get my head around this. Basically i'm trying to create a sheet whereby we can compare carriage costs between two companies using drop down lists. So if we select the Zone and Pallet Type (Which are drop...